/// <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())));
}
