/// <summary>
/// 得到一个对象实体
/// </summary>
public abc.Model.Model.AskNotifyPlanMember DataRowToModel(DataRow row)
{
abc.Model.Model.AskNotifyPlanMember model = new abc.Model.Model.AskNotifyPlanMember();
if (row != null)
{
if (row["NotifyMId"] != null && row["NotifyMId"].ToString() != "")
{
model.NotifyMId = int.Parse(row["NotifyMId"].ToString());
}
if (row["NotifyId"] != null)
{
model.NotifyId = row["NotifyId"].ToString();
}
if (row["AskId"] != null && row["AskId"].ToString() != "")
{
model.AskId = int.Parse(row["AskId"].ToString());
}
if (row["ReceiverId"] != null && row["ReceiverId"].ToString() != "")
{
model.ReceiverId = int.Parse(row["ReceiverId"].ToString());
}
if (row["Content"] != null)
{
model.Content = row["Content"].ToString();
}
if (row["IsSend"] != null && row["IsSend"].ToString() != "")
{
model.IsSend = int.Parse(row["IsSend"].ToString());
}
if (row["SendDate"] != null)
{
model.SendDate = row["SendDate"].ToString();
}
if (row["OrderBy"] != null && row["OrderBy"].ToString() != "")
{
model.OrderBy = int.Parse(row["OrderBy"].ToString());
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(abc.Model.Model.AskNotifyPlanMember model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update AskNotifyPlanMember set ");
strSql.Append("Content=SQL2012Content,");
strSql.Append("IsSend=SQL2012IsSend,");
strSql.Append("SendDate=SQL2012SendDate,");
strSql.Append("OrderBy=SQL2012OrderBy,");
strSql.Append("CreateTime=SQL2012CreateTime");
strSql.Append(" where NotifyMId=SQL2012NotifyMId");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012Content", SqlDbType.VarChar, 4000),
new SqlParameter("SQL2012IsSend", SqlDbType.Int, 4),
new SqlParameter("SQL2012SendDate", SqlDbType.VarChar, 4000),
new SqlParameter("SQL2012OrderBy", SqlDbType.Int, 4),
new SqlParameter("SQL2012CreateTime", SqlDbType.DateTime),
new SqlParameter("SQL2012NotifyMId", SqlDbType.Int, 4),
new SqlParameter("SQL2012NotifyId", SqlDbType.VarChar, 4000),
new SqlParameter("SQL2012AskId", SqlDbType.Int, 4),
new SqlParameter("SQL2012ReceiverId", SqlDbType.Int, 4)
};
parameters[0].Value = model.Content;
parameters[1].Value = model.IsSend;
parameters[2].Value = model.SendDate;
parameters[3].Value = model.OrderBy;
parameters[4].Value = model.CreateTime;
parameters[5].Value = model.NotifyMId;
parameters[6].Value = model.NotifyId;
parameters[7].Value = model.AskId;
parameters[8].Value = model.ReceiverId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(abc.Model.Model.AskNotifyPlanMember model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into AskNotifyPlanMember(");
strSql.Append("NotifyId,AskId,ReceiverId,Content,IsSend,SendDate,OrderBy,CreateTime)");
strSql.Append(" values (");
strSql.Append("SQL2012NotifyId,SQL2012AskId,SQL2012ReceiverId,SQL2012Content,SQL2012IsSend,SQL2012SendDate,SQL2012OrderBy,SQL2012CreateTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012NotifyId", SqlDbType.VarChar, 4000),
new SqlParameter("SQL2012AskId", SqlDbType.Int, 4),
new SqlParameter("SQL2012ReceiverId", SqlDbType.Int, 4),
new SqlParameter("SQL2012Content", SqlDbType.VarChar, 4000),
new SqlParameter("SQL2012IsSend", SqlDbType.Int, 4),
new SqlParameter("SQL2012SendDate", SqlDbType.VarChar, 4000),
new SqlParameter("SQL2012OrderBy", SqlDbType.Int, 4),
new SqlParameter("SQL2012CreateTime", SqlDbType.DateTime)
};
parameters[0].Value = model.NotifyId;
parameters[1].Value = model.AskId;
parameters[2].Value = model.ReceiverId;
parameters[3].Value = model.Content;
parameters[4].Value = model.IsSend;
parameters[5].Value = model.SendDate;
parameters[6].Value = model.OrderBy;
parameters[7].Value = model.CreateTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public abc.Model.Model.AskNotifyPlanMember GetModel(int NotifyMId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 NotifyMId,NotifyId,AskId,ReceiverId,Content,IsSend,SendDate,OrderBy,CreateTime from AskNotifyPlanMember ");
strSql.Append(" where NotifyMId=SQL2012NotifyMId");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012NotifyMId", SqlDbType.Int, 4)
};
parameters[0].Value = NotifyMId;
abc.Model.Model.AskNotifyPlanMember model = new abc.Model.Model.AskNotifyPlanMember();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
