/// <summary>
/// 修改数据记录
/// </summary>
///<param name="model">实体类</param>
/// <returns>修改数据是否成功:true成功,false不成功</returns>
public static bool Update(PersonalDateArrangeModel model)
{
ArrayList sqlList = new ArrayList();
sqlList.Add(PersonalDateArrangeDBHelper.UpdateCommand(model));
sqlList.Add(PersonalDateArrangeDBHelper.InsertMessage(model));
if (SqlHelper.ExecuteTransWithArrayList(sqlList))
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 插入数据记录
/// </summary>
///<param name="model">实体类</param>
/// <returns>插入数据是否成功:true成功,false不成功</returns>
public static bool Insert(PersonalDateArrangeModel model)
{
ArrayList sqlList = new ArrayList();
SqlCommand cmd = PersonalDateArrangeDBHelper.InsertCommand(model);
sqlList.Add(cmd);
if (SqlHelper.ExecuteTransWithArrayList(sqlList))
{
int i = 0;
if (int.TryParse(cmd.Parameters["@IndexID"].Value.ToString(), out i))
{
model.ID = i;
}
sqlList.Clear();
sqlList.Add(PersonalDateArrangeDBHelper.InsertMessage(model));
SqlHelper.ExecuteTransWithArrayList(sqlList);
return(true);
}
else
{
return(false);
}
}
