public Model_SyncData DataRowToModel(DataRow row) { Model_SyncData data = new Model_SyncData(); if (row != null) { if (row["SyncDataId"] != null) { data.SyncDataId = row["SyncDataId"].ToString(); } if (row["TableName"] != null) { data.TableName = row["TableName"].ToString(); } if (row["DataId"] != null) { data.DataId = row["DataId"].ToString(); } if (row["OperateType"] != null) { data.OperateType = row["OperateType"].ToString(); } if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != "")) { data.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString())); } if (row["SyncStatus"] != null) { data.SyncStatus = row["SyncStatus"].ToString(); } } return(data); }
public bool Add(Model_SyncData model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into SyncData("); builder.Append("SyncDataId,TableName,DataId,OperateType,CreateTime,SyncStatus)"); builder.Append(" values ("); builder.Append("@SyncDataId,@TableName,@DataId,@OperateType,@CreateTime,@SyncStatus)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SyncDataId", SqlDbType.Char, 0x24), new SqlParameter("@TableName", SqlDbType.VarChar, 100), new SqlParameter("@DataId", SqlDbType.Char, 0x24), new SqlParameter("@OperateType", SqlDbType.VarChar, 50), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@SyncStatus", SqlDbType.VarChar, 50) }; cmdParms[0].Value = model.SyncDataId; cmdParms[1].Value = model.TableName; cmdParms[2].Value = model.DataId; cmdParms[3].Value = model.OperateType; cmdParms[4].Value = model.CreateTime; cmdParms[5].Value = model.SyncStatus; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public List <Model_SyncData> DataTableToList(DataTable dt) { List <Model_SyncData> list = new List <Model_SyncData>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_SyncData item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public bool Update(Model_SyncData model) { StringBuilder builder = new StringBuilder(); builder.Append("update SyncData set "); builder.Append("TableName=@TableName,"); builder.Append("DataId=@DataId,"); builder.Append("OperateType=@OperateType,"); builder.Append("CreateTime=@CreateTime,"); builder.Append("SyncStatus=@SyncStatus"); builder.Append(" where SyncDataId=@SyncDataId "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@TableName", SqlDbType.VarChar, 100), new SqlParameter("@DataId", SqlDbType.Char, 0x24), new SqlParameter("@OperateType", SqlDbType.VarChar, 50), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@SyncStatus", SqlDbType.VarChar, 50), new SqlParameter("@SyncDataId", SqlDbType.Char, 0x24) }; cmdParms[0].Value = model.TableName; cmdParms[1].Value = model.DataId; cmdParms[2].Value = model.OperateType; cmdParms[3].Value = model.CreateTime; cmdParms[4].Value = model.SyncStatus; cmdParms[5].Value = model.SyncDataId; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public static string BookAudit(string reid, string rename, string type) { try { Model_VSysUserRole loginUser = HttpContext.Current.Session["LoginUser"] as Model_VSysUserRole; reid = reid.Filter(); type = type.Filter(); Model_BookAudit model = new Model_BookAudit(); BLL_BookAudit bll = new BLL_BookAudit(); Model_SyncData modelSD = new Model_SyncData(); model = bll.GetModel(reid); if (model == null) { model = new Model_BookAudit(); if (type == "1") { model.AuditState = "1"; model.ResourceFolder_Id = reid; model.Book_Name = rename; model.CreateTime = DateTime.Now; model.CreateUser = loginUser.SysUser_ID; #region 审核通过,记录同步数据 modelSD.SyncDataId = Guid.NewGuid().ToString(); modelSD.TableName = "BookAudit"; modelSD.DataId = reid; modelSD.OperateType = "bookaudit"; modelSD.CreateTime = DateTime.Now; modelSD.SyncStatus = "0"; #endregion } else { model.AuditState = "0"; model.ResourceFolder_Id = reid; model.Book_Name = rename; model.CreateTime = DateTime.Now; model.CreateUser = loginUser.SysUser_ID; } if (bll.Add(model)) { if (modelSD.SyncDataId != null) { new BLL_SyncData().Add(modelSD); } return("1"); } else { return("2"); } } else { if (type == "1") { model = bll.GetModel(reid); model.AuditState = "1"; model.CreateTime = DateTime.Now; model.CreateUser = loginUser.SysUser_ID; #region 审核通过,记录同步数据 modelSD.SyncDataId = Guid.NewGuid().ToString(); modelSD.TableName = "BookAudit"; modelSD.DataId = reid; modelSD.OperateType = "bookaudit"; modelSD.CreateTime = DateTime.Now; modelSD.SyncStatus = "0"; #endregion } else { model = bll.GetModel(reid); model.AuditState = "0"; model.CreateTime = DateTime.Now; model.CreateUser = loginUser.SysUser_ID; } if (bll.Update(model)) { if (modelSD.SyncDataId != null) { new BLL_SyncData().Add(modelSD); } return("1"); } else { return("2"); } } } catch (Exception) { return(JsonConvert.SerializeObject(new { err = "error"//ex.Message.ToString() })); } }
public bool Add(Model_SyncData model) { return(this.dal.Add(model)); }
public bool Update(Model_SyncData model) { return(this.dal.Update(model)); }