public OperationResult <bool> UserRemind_Insert(UserRemindEntity entity)
{
SqlTransaction trans = null;
try
{
string sql = string.Empty;
sql += " INSERT INTO M_User_Remind(UserID,RemindTypeID,Data,UpdateTime) ";
sql += " VALUES(@UserID,@RemindTypeID,@Data,@UpdateTime) ";
SqlParameter[] prms =
{
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@RemindTypeID", SqlDbType.Int),
new SqlParameter("@Data", SqlDbType.NVarChar,128),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
};
prms[0].Value = entity.UserID;
prms[1].Value = entity.RemindTypeID;
prms[2].Value = entity.Data;
prms[3].Value = DateTime.Now;
using (SqlConnection conn = new SqlConnection(SQlHelper.MyConnectStr))
{
conn.Open();
trans = conn.BeginTransaction();
SQlHelper.ExecuteScalar(trans, CommandType.Text, sql, prms);
trans.Commit();
}
return(new OperationResult <bool>(OperationResultType.Success, "数据加入成功！", true));
}
catch (Exception ex)
{
try
{
if (trans != null)
{
trans.Rollback();
}
}
catch { }
return(new OperationResult <bool>(OperationResultType.Error, "异常结果：" + ex.Message, false));
}
}
void LoadUseRemindComplete(object sender, EventArgs e)
{
UserRemindEntityDicationary.Clear();
LoadOperation loadOperation = sender as LoadOperation;
foreach (user_remind user_remind in loadOperation.Entities)
{
UserRemindEntity lUserRemindEntity = new UserRemindEntity();
lUserRemindEntity.UserRemind = user_remind;
lUserRemindEntity.Update();
UserRemindEntityDicationary.Add(lUserRemindEntity.ManufactureNumber, lUserRemindEntity);
}
LoadOperation <ProductManager.Web.Model.project> LoadOperationProject =
productDomainContext.Load <ProductManager.Web.Model.project>(productDomainContext.GetProjectQuery());
LoadOperationProject.Completed += loadOperationProject_Completed;
}
