/// <summary> /// 更新一条数据 /// </summary> public static Hashtable Update(Sys_Language model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("update Sys_Language set "); strSql.Append(" Status = @Status , "); strSql.Append(" Code = @Code , "); strSql.Append(" ZHName = @ZHName , "); strSql.Append(" ENName = @ENName , "); strSql.Append(" CreatedTime = @CreatedTime , "); strSql.Append(" CreatedBy = @CreatedBy , "); strSql.Append(" UpdatedTime = @UpdatedTime , "); strSql.Append(" UpdatedBy = @UpdatedBy , "); strSql.Append(" IsDeleted = @IsDeleted, "); strSql.Append(" Remark = @Remark, "); strSql.Append(" LanguageCode = @LanguageCode, "); strSql.Append(" Sort = @Sort "); strSql.Append(" where Id=@Id "); strSql.AppendFormat(" ;select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.BigInt, 8), new SqlParameter("@Status", SqlDbType.Bit, 1), new SqlParameter("@Code", SqlDbType.VarChar, 40), new SqlParameter("@ZHName", SqlDbType.NVarChar, 500), new SqlParameter("@ENName", SqlDbType.NVarChar, 500), new SqlParameter("@CreatedTime", SqlDbType.DateTime), new SqlParameter("@CreatedBy", SqlDbType.VarChar, 40), new SqlParameter("@UpdatedTime", SqlDbType.DateTime), new SqlParameter("@UpdatedBy", SqlDbType.VarChar, 40), new SqlParameter("@IsDeleted", SqlDbType.Bit, 1), new SqlParameter("@Remark", SqlDbType.VarChar, 1000), new SqlParameter("@Sort", SqlDbType.BigInt), new SqlParameter("@LanguageCode", SqlDbType.VarChar, 50) }; parameters[0].Value = model.Id; parameters[1].Value = model.Status; parameters[2].Value = model.Code; parameters[3].Value = model.ZHName; parameters[4].Value = model.ENName; parameters[5].Value = model.CreatedTime; parameters[6].Value = model.CreatedBy; parameters[7].Value = model.UpdatedTime; parameters[8].Value = model.UpdatedBy; parameters[9].Value = model.IsDeleted; parameters[10].Value = model.Remark; parameters[11].Value = model.Sort; parameters[12].Value = model.LanguageCode; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
protected override string btnAdd_Click() { Sys_Language language = Language; if (language.ENName.Contains("\"") || language.ZHName.Contains("\"")) { return("非法操作符(\")"); } if (Sys_LanguageBLL.SaveOrUpdate(Language)) { return("操作成功"); } return("操作失败"); }
/// <summary> /// 实体转换 /// <summary> private static Sys_Language TranEntity(DataRow dr) { if (dr != null) { Sys_Language model = new Sys_Language(); if (!string.IsNullOrEmpty(dr["Id"].ToString())) { model.Id = long.Parse(dr["Id"].ToString()); } if (!string.IsNullOrEmpty(dr["Status"].ToString())) { model.Status = bool.Parse(dr["Status"].ToString()); } model.Code = dr["Code"].ToString(); model.ZHName = dr["ZHName"].ToString(); model.ENName = dr["ENName"].ToString(); model.Remark = dr["Remark"].ToString(); if (!string.IsNullOrEmpty(dr["CreatedTime"].ToString())) { model.CreatedTime = DateTime.Parse(dr["CreatedTime"].ToString()); } model.CreatedBy = dr["CreatedBy"].ToString(); if (!string.IsNullOrEmpty(dr["UpdatedTime"].ToString())) { model.UpdatedTime = DateTime.Parse(dr["UpdatedTime"].ToString()); } model.UpdatedBy = dr["UpdatedBy"].ToString(); if (!string.IsNullOrEmpty(dr["IsDeleted"].ToString())) { model.IsDeleted = bool.Parse(dr["IsDeleted"].ToString()); } if (!string.IsNullOrEmpty(dr["Sort"].ToString())) { model.Sort = long.Parse(dr["Sort"].ToString()); } return(model); } else { return(null); } }
public static bool SaveOrUpdate(Sys_Language obj) { bool result = false; if (obj.Id == 0) //需要插入的 { result = Sys_LanguageDAL.Insert(obj); } else { //需要更新的 result = Sys_LanguageDAL.Update(obj); } return(result); }
/// <summary> /// 增加一条数据 /// </summary> public static Hashtable Insert(Sys_Language model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_Language("); strSql.Append("Status,Code,ZHName,ENName,CreatedTime,CreatedBy,UpdatedTime,UpdatedBy,IsDeleted,Remark,Sort,LanguageCode"); strSql.Append(") values ("); strSql.Append("@Status,@Code,@ZHName,@ENName,@CreatedTime,@CreatedBy,@UpdatedTime,@UpdatedBy,@IsDeleted,@Remark,@Sort,@LanguageCode"); strSql.Append(") "); strSql.AppendFormat(";select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@Status", SqlDbType.Bit, 1), new SqlParameter("@Code", SqlDbType.VarChar, 40), new SqlParameter("@ZHName", SqlDbType.NVarChar, 500), new SqlParameter("@ENName", SqlDbType.NVarChar, 500), new SqlParameter("@CreatedTime", SqlDbType.DateTime), new SqlParameter("@CreatedBy", SqlDbType.VarChar, 40), new SqlParameter("@UpdatedTime", SqlDbType.DateTime), new SqlParameter("@UpdatedBy", SqlDbType.VarChar, 40), new SqlParameter("@IsDeleted", SqlDbType.Bit, 1), new SqlParameter("@Remark", SqlDbType.VarChar, 1000), new SqlParameter("@Sort", SqlDbType.BigInt), new SqlParameter("@LanguageCode", SqlDbType.VarChar, 50) }; parameters[0].Value = model.Status; parameters[1].Value = model.Code; parameters[2].Value = model.ZHName; parameters[3].Value = model.ENName; parameters[4].Value = model.CreatedTime; parameters[5].Value = model.CreatedBy; parameters[6].Value = model.UpdatedTime; parameters[7].Value = model.UpdatedBy; parameters[8].Value = model.IsDeleted; parameters[9].Value = model.Remark; parameters[10].Value = model.Sort; parameters[11].Value = model.LanguageCode; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
public static int SaveOrUpdate(IList <Sys_Language> list) { int result = 0; foreach (Sys_Language obj in list) { if (obj.Id == 0) //需要插入的 { Sys_LanguageDAL.Insert(obj); } else { //需要更新的 Sys_Language objUpdate = obj; Sys_LanguageDAL.Update(obj); } result++; } return(result); }
/// <summary> /// 将Dataset的数据导入数据库 /// </summary> /// <param name="pds">数据集</param> /// <param name="Cols">数据集列数</param> /// <returns></returns> private string AddDatasetToSQL(DataSet pds) { int totalCount = 0; //Excel中的总行数 long realInport = 0; //实际导入数量 int errors = 0; //导入出错数量 int updateCount = 0, inserCount = 0; StringBuilder errInfo = new StringBuilder(); //导入出错信息 IList <Sys_Language> qList = new List <Sys_Language>(); DataTable dtExcel = pds.Tables[0]; for (int i = 0; i < dtExcel.Rows.Count; i++) { totalCount++; //保存题目 Sys_Language objQ = new Sys_Language(); objQ.Code = Guid.NewGuid().ToString().Replace("-", "").Replace(" ", ""); if (string.IsNullOrEmpty(dtExcel.Rows[i][0].ToString().Trim())) { errors++; errInfo.Append("第【" + (i + 1).ToString() + "】行【" + dtExcel.Columns[0].ColumnName + "】单元格不能为空<br/>"); } else { objQ.ZHName = dtExcel.Rows[i][0].ToString(); } if (string.IsNullOrEmpty(dtExcel.Rows[i][1].ToString().Trim())) { errors++; errInfo.Append("第【" + (i + 1).ToString() + "】行【" + dtExcel.Columns[1].ColumnName + "】单元格不能为空<br/>"); } else { objQ.ENName = dtExcel.Rows[i][1].ToString(); } if (string.IsNullOrEmpty(dtExcel.Rows[i][2].ToString().Trim())) { errors++; errInfo.Append("第【" + (i + 1).ToString() + "】行【" + dtExcel.Columns[2].ColumnName + "】单元格不能为空<br/>"); } else { if (dtExcel.Rows[i][2].ToString() == "是") { objQ.Status = true; } else if (dtExcel.Rows[i][2].ToString() == "否") { objQ.Status = false; } else { objQ.Status = true; } } objQ.Sort = 1; qList.Add(objQ); } if (errors > 0) { //有错,显示出错信息 // divInfo.InnerHtml = errInfo.ToString(); return(errInfo.ToString()); } else { List <Sys_Language> inserOrUpdateList = new List <Sys_Language>(); foreach (Sys_Language obj in qList) { //找到要修改的 List <Sys_Language> lanList = Sys_LanguageBLL.GetList("ZHName=N'" + obj.ZHName + "'"); if (lanList != null && lanList.Count > 0) { //看看是否是一样的,全部一样就不执行数据库操作 List <Sys_Language> lanList2 = lanList.Where(c => c.Status == obj.Status && c.ENName == obj.ENName).ToList(); if (lanList2 == null || lanList2.Count <= 0)//没有全部一样的,只是有ZHName一样,就修改 { Sys_Language objForUpdate = lanList[0]; objForUpdate.UpdatedTime = DateTime.Now; objForUpdate.ENName = obj.ENName; objForUpdate.Sort = obj.Sort; objForUpdate.Status = obj.Status; objForUpdate.UpdatedBy = TModel.MID; inserOrUpdateList.Add(objForUpdate); updateCount++; } } else { //新增加的 obj.Code = Guid.NewGuid().ToString().Replace("-", "").Replace(" ", ""); obj.CreatedBy = TModel.MID; obj.CreatedTime = DateTime.Now; inserOrUpdateList.Add(obj); inserCount++; } } Sys_LanguageBLL.SaveOrUpdate(inserOrUpdateList); } return("总行数:" + totalCount.ToString() + ",修改:" + updateCount.ToString() + ",新增:" + inserCount.ToString()); }
public static bool Update(Sys_Language model) { return(Sys_LanguageDAL.Update(model)); }
public static Hashtable Update(Sys_Language model, Hashtable MyHs) { return(Sys_LanguageDAL.Update(model, MyHs)); }
public static bool Insert(Sys_Language model) { return(Sys_LanguageDAL.Insert(model)); }
public static Hashtable Insert(Sys_Language model, Hashtable MyHs) { return(Sys_LanguageDAL.Insert(model, MyHs)); }
/// <summary> /// 增加一条数据 /// </summary> public static bool Insert(Sys_Language model) { return(CommonBase.RunHashtable(Insert(model, new Hashtable()))); }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(Sys_Language model) { return(CommonBase.RunHashtable(Update(model, new Hashtable()))); }