<برنامه نویس>
دوشنبه 10 آبان 1389, 23:06 عصر
سلام دوستان ميشه نحوه نوشتن كد ها در كلاس رو نشون بديد براي اضافه -پاك كردن -اضلاح ديتا بيس مثل اين كد يعني جطوري بايد نوشت و چطوري ميشه ازش استفاده كرد مثا اين كد
using System;
using System.Data;
public class Post
{
#region Fields
private int id;
private string title;
private string body;
private DateTime createdTime;
private int userId;
#endregion Fields
#region Properties
public int Id
{
get { return id; }
set { id = value; }
}
public string Title
{
get { return title; }
set { title = value; }
}
public string Body
{
get { return body; }
set { body = value; }
}
public DateTime CreatedTime
{
get { return createdTime; }
set { createdTime = value; }
}
public int UserId
{
get { return userId; }
set { userId = value; }
}
#endregion Properties
#region Constructor
public Post()
{
}
#endregion Constructor
#region Methods
public void Add()
{
try
{
DataAccessLayer dal = new DataAccessLayer();
dal.Connect();
string command = "INSERT INTO post VALUES(N'{0}',N'{1}',N'{2}',N'{3}')";
command = string.Format(command, title, body, createdTime, userId);
dal.DoCommand(command);
}
catch (Exception)
{
throw;
}
}
public void Edit()
{
try
{
DataAccessLayer dal = new DataAccessLayer();
dal.Connect();
string command = "UPDATE post SET title = N'{0}', body =N'{1}', createdtime =N'{2}', userid = {3} WHERE id = {4}";
command = string.Format(command, title, body, createdTime, userId, id);
dal.DoCommand(command);
dal.Disconnect();
}
catch
{
throw;
}
}
public Post[] Select()
{
DataAccessLayer da = new DataAccessLayer();
da.Connect();
DataTable dt = da.Select("Select top 3 * from post where userid="+this.UserId+" order by id desc");
DataTableReader reader = dt.CreateDataReader();
Post[] retuns = new Post[dt.Rows.Count];
Post tmpPost = null;
int i = 0;
while (reader.Read())
{
tmpPost = new Post();
tmpPost.id = reader.GetInt32(0);
tmpPost.title = reader.GetString(1);
tmpPost.body = reader.GetString(2);
tmpPost.createdTime = reader.GetDateTime(3);
tmpPost.userId = reader.GetInt32(4);
retuns[i] = tmpPost;
i++;
}
da.Disconnect();
return retuns;
}
public Post Read(int _userid)
{
try
{
DataAccessLayer dal = new DataAccessLayer();
Post tmpPost = null;
DataTableReader reader = dal.Select("SELECT * FROM post WHERE id = " + Id+" and userid="+_userid).CreateDataReader();
while (reader.Read())
{
tmpPost = new Post();
tmpPost.id = reader.GetInt32(0);
tmpPost.title = reader.GetString(1);
tmpPost.body = reader.GetString(2);
tmpPost.createdTime = reader.GetDateTime(3);
tmpPost.userId = reader.GetInt32(4);
}
return tmpPost;
}
catch
{
throw;
}
}
public void Delete(int _userid)
{
try
{
DataAccessLayer dal = new DataAccessLayer();
dal.Connect();
string command = "DELETE FROM post WHERE id = " + Id+" and userid="+_userid;
dal.DoCommand(command);
dal.Disconnect();
}
catch
{
throw;
}
}
#endregion Methods
}
البته اين يك نمونه است كه با cشارپ نوشته شده
using System;
using System.Data;
public class Post
{
#region Fields
private int id;
private string title;
private string body;
private DateTime createdTime;
private int userId;
#endregion Fields
#region Properties
public int Id
{
get { return id; }
set { id = value; }
}
public string Title
{
get { return title; }
set { title = value; }
}
public string Body
{
get { return body; }
set { body = value; }
}
public DateTime CreatedTime
{
get { return createdTime; }
set { createdTime = value; }
}
public int UserId
{
get { return userId; }
set { userId = value; }
}
#endregion Properties
#region Constructor
public Post()
{
}
#endregion Constructor
#region Methods
public void Add()
{
try
{
DataAccessLayer dal = new DataAccessLayer();
dal.Connect();
string command = "INSERT INTO post VALUES(N'{0}',N'{1}',N'{2}',N'{3}')";
command = string.Format(command, title, body, createdTime, userId);
dal.DoCommand(command);
}
catch (Exception)
{
throw;
}
}
public void Edit()
{
try
{
DataAccessLayer dal = new DataAccessLayer();
dal.Connect();
string command = "UPDATE post SET title = N'{0}', body =N'{1}', createdtime =N'{2}', userid = {3} WHERE id = {4}";
command = string.Format(command, title, body, createdTime, userId, id);
dal.DoCommand(command);
dal.Disconnect();
}
catch
{
throw;
}
}
public Post[] Select()
{
DataAccessLayer da = new DataAccessLayer();
da.Connect();
DataTable dt = da.Select("Select top 3 * from post where userid="+this.UserId+" order by id desc");
DataTableReader reader = dt.CreateDataReader();
Post[] retuns = new Post[dt.Rows.Count];
Post tmpPost = null;
int i = 0;
while (reader.Read())
{
tmpPost = new Post();
tmpPost.id = reader.GetInt32(0);
tmpPost.title = reader.GetString(1);
tmpPost.body = reader.GetString(2);
tmpPost.createdTime = reader.GetDateTime(3);
tmpPost.userId = reader.GetInt32(4);
retuns[i] = tmpPost;
i++;
}
da.Disconnect();
return retuns;
}
public Post Read(int _userid)
{
try
{
DataAccessLayer dal = new DataAccessLayer();
Post tmpPost = null;
DataTableReader reader = dal.Select("SELECT * FROM post WHERE id = " + Id+" and userid="+_userid).CreateDataReader();
while (reader.Read())
{
tmpPost = new Post();
tmpPost.id = reader.GetInt32(0);
tmpPost.title = reader.GetString(1);
tmpPost.body = reader.GetString(2);
tmpPost.createdTime = reader.GetDateTime(3);
tmpPost.userId = reader.GetInt32(4);
}
return tmpPost;
}
catch
{
throw;
}
}
public void Delete(int _userid)
{
try
{
DataAccessLayer dal = new DataAccessLayer();
dal.Connect();
string command = "DELETE FROM post WHERE id = " + Id+" and userid="+_userid;
dal.DoCommand(command);
dal.Disconnect();
}
catch
{
throw;
}
}
#endregion Methods
}
البته اين يك نمونه است كه با cشارپ نوشته شده