/// <summary> /// 增加一条数据 /// </summary> public bool Add(IndustryPlatform.Model.SYS_DictionaryEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_Dictionary("); strSql.Append("BusinID,BusinName,BusinTypeID,DisplayOrder,IsForbid)"); strSql.Append(" values ("); strSql.Append("@BusinID,@BusinName,@BusinTypeID,@DisplayOrder,@IsForbid)"); SqlParameter[] parameters = { new SqlParameter("@BusinID", SqlDbType.VarChar,10), new SqlParameter("@BusinName", SqlDbType.NVarChar,50), new SqlParameter("@BusinTypeID", SqlDbType.VarChar,10), new SqlParameter("@DisplayOrder", SqlDbType.Decimal,5), new SqlParameter("@IsForbid", SqlDbType.VarChar,1)}; try { parameters[0].Value = model.BusinID; parameters[1].Value = model.BusinName; parameters[2].Value = model.BusinTypeID; parameters[3].Value = model.DisplayOrder; parameters[4].Value = model.IsForbid; if (DbHelperSQL.ExecuteSql(strSql.ToString(), parameters) > 0) { return true; } else { return false; } } catch { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(IndustryPlatform.Model.SYS_Organization model) { try { lock (this) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_Organization("); strSql.Append("OrgCode,OrgName,OrgLevel,ParentOrgCode,OrgSeq,OrgType,LinkMan,LinkManTel,Email,IsForbid,Remark,SysCode)"); strSql.Append(" values ("); strSql.Append("@OrgCode,@OrgName,@OrgLevel,@ParentOrgCode,@OrgSeq,@OrgType,@LinkMan,@LinkManTel,@Email,@IsForbid,@Remark,@SysCode)"); SqlParameter[] parameters = { new SqlParameter("@OrgCode", SqlDbType.VarChar,10), new SqlParameter("@OrgName", SqlDbType.NVarChar,50), new SqlParameter("@OrgLevel", SqlDbType.VarChar,1), new SqlParameter("@ParentOrgCode", SqlDbType.VarChar,10), new SqlParameter("@OrgSeq", SqlDbType.NVarChar,300), new SqlParameter("@OrgType", SqlDbType.VarChar,1), new SqlParameter("@LinkMan", SqlDbType.NVarChar,20), new SqlParameter("@LinkManTel", SqlDbType.NVarChar,20), new SqlParameter("@Email", SqlDbType.NVarChar,100), new SqlParameter("@IsForbid", SqlDbType.VarChar,1), new SqlParameter("@Remark", SqlDbType.NVarChar,200), new SqlParameter("@SysCode", SqlDbType.VarChar,4)}; int iKey = DbHelperSQL.GetMaxID("OrgCode", "SYS_Organization"); string strSEQ = ""; if (model.ParentOrgCode == "0") strSEQ = iKey + "."; else strSEQ = GetModel(model.ParentOrgCode).OrgSeq + iKey + "."; model.OrgSeq = strSEQ; parameters[0].Value = model.OrgCode; parameters[1].Value = model.OrgName; parameters[2].Value = model.OrgLevel; parameters[3].Value = model.ParentOrgCode; parameters[4].Value = model.OrgSeq; parameters[5].Value = model.OrgType; parameters[6].Value = model.LinkMan; parameters[7].Value = model.LinkManTel; parameters[8].Value = model.Email; parameters[9].Value = model.IsForbid; parameters[10].Value = model.Remark; parameters[11].Value = model.SysCode; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); return 1; } } catch { return 0; } }
/// <summary> /// 更新一条数据 /// </summary> public int Update(IndustryPlatform.Model.SYS_Organization model) { try { List<string> listSql = new List<string>(); List<SqlParameter[]> listParm = new List<SqlParameter[]>(); string strOldSEQ = GetModel(model.OrgCode).OrgSeq; string strNewSEQ = model.OrgCode + "."; if (model.ParentOrgCode != "0") { IndustryPlatform.Model.SYS_Organization p=GetModel(model.ParentOrgCode); strNewSEQ = p.OrgSeq + model.OrgCode+"."; } //更新序列 string strSqlSeq = "update SYS_Organization set OrgSeq='" + strNewSEQ + "'+ replace(OrgSeq,'" + strOldSEQ + "','') where OrgSeq like '" + strOldSEQ + "%'"; //DbHelperSQL.ExecuteSql(strSqlSeq); listSql.Add(strSqlSeq); listParm.Add(null); //更新Level string strSqlLevel = "Update SYS_Organization set orgLevel=len(orgSEQ)-len(replace(orgSEQ,'.' , '')) where orgSEQ like '" + strNewSEQ + "%'"; listSql.Add(strSqlLevel); listParm.Add(null); //DbHelperSQL.ExecuteSql(strSqlLevel); StringBuilder strSql = new StringBuilder(); strSql.Append("update Sys_Organization set "); strSql.Append("OrgName=@OrgName,"); strSql.Append("OrgLevel=@OrgLevel,"); strSql.Append("ParentOrgCode=@ParentOrgCode,"); strSql.Append("OrgSeq=@OrgSeq,"); strSql.Append("OrgType=@OrgType,"); strSql.Append("LinkMan=@LinkMan,"); strSql.Append("LinkManTel=@LinkManTel,"); strSql.Append("Email=@Email,"); strSql.Append("IsForbid=@IsForbid,"); strSql.Append("Remark=@Remark,"); strSql.Append("SysCode=@SysCode"); strSql.Append(" where OrgCode=@OrgCode "); SqlParameter[] parameters = { new SqlParameter("@OrgCode", SqlDbType.VarChar,10), new SqlParameter("@OrgName", SqlDbType.NVarChar,50), new SqlParameter("@OrgLevel", SqlDbType.VarChar,1), new SqlParameter("@ParentOrgCode", SqlDbType.VarChar,10), new SqlParameter("@OrgSeq", SqlDbType.NVarChar,300), new SqlParameter("@OrgType", SqlDbType.VarChar,1), new SqlParameter("@LinkMan", SqlDbType.NVarChar,20), new SqlParameter("@LinkManTel", SqlDbType.NVarChar,20), new SqlParameter("@Email", SqlDbType.NVarChar,100), new SqlParameter("@IsForbid", SqlDbType.VarChar,1), new SqlParameter("@Remark", SqlDbType.NVarChar,200), new SqlParameter("@SysCode", SqlDbType.VarChar,4)}; parameters[0].Value = model.OrgCode; parameters[1].Value = model.OrgName; parameters[2].Value = model.OrgLevel; parameters[3].Value = model.ParentOrgCode; parameters[4].Value = strNewSEQ; parameters[5].Value = model.OrgType; parameters[6].Value = model.LinkMan; parameters[7].Value = model.LinkManTel; parameters[8].Value = model.Email; parameters[9].Value = model.IsForbid; parameters[10].Value = model.Remark; parameters[11].Value = model.SysCode; listSql.Add(strSql.ToString()); listParm.Add(parameters); //DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); DbHelperSQL.ExecuteSqlCake(listSql, listParm); return 1; } catch { return 0; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(IndustryPlatform.Model.SYS_Organization model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(IndustryPlatform.Model.SYS_Organization model) { return dal.Update(model); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(IndustryPlatform.Model.Sys_Colliery model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sys_Colliery set "); strSql.Append("CollName=@CollName,"); strSql.Append("OrgCode=@OrgCode,"); strSql.Append("VillageCode=@VillageCode,"); strSql.Append("MineOwner=@MineOwner,"); strSql.Append("MinePhone=@MinePhone,"); strSql.Append("YearOutput=@YearOutput,"); strSql.Append("CollState=@CollState,"); strSql.Append("ImageLicence=@ImageLicence,"); strSql.Append("ImageRevenue=@ImageRevenue,"); strSql.Append("ImageCompetency=@ImageCompetency,"); strSql.Append("Remark=@Remark,"); strSql.Append("IsForbid=@IsForbid,"); strSql.Append("CollProperty=@CollProperty");//煤矿属性 strSql.Append(" where CollCode=@CollCode "); SqlParameter[] parameters = { new SqlParameter("@CollCode", SqlDbType.VarChar,20), new SqlParameter("@CollName", SqlDbType.VarChar,50), new SqlParameter("@OrgCode", SqlDbType.Decimal,9), new SqlParameter("@VillageCode", SqlDbType.VarChar,4), new SqlParameter("@MineOwner", SqlDbType.VarChar,20), new SqlParameter("@MinePhone", SqlDbType.VarChar,30), new SqlParameter("@YearOutput", SqlDbType.Decimal,9), new SqlParameter("@CollState", SqlDbType.VarChar,10), new SqlParameter("@ImageLicence", SqlDbType.VarChar,32), new SqlParameter("@LicenceImageType", SqlDbType.VarChar,10), new SqlParameter("@ImageRevenue", SqlDbType.VarChar,32), new SqlParameter("@RevenueImageType", SqlDbType.VarChar,10), new SqlParameter("@ImageCompetency", SqlDbType.VarChar,32), new SqlParameter("@CompetencyImageType", SqlDbType.VarChar,10), new SqlParameter("@Remark", SqlDbType.VarChar,200), new SqlParameter("@IsForbid", SqlDbType.VarChar,1), new SqlParameter("@CollProperty",SqlDbType.VarChar,1)}; parameters[0].Value = model.CollCode; parameters[1].Value = model.CollName; parameters[2].Value = model.OrgCode; parameters[3].Value = model.VillageCode; parameters[4].Value = model.MineOwner; parameters[5].Value = model.MinePhone; parameters[6].Value = model.YearOutput; parameters[7].Value = model.CollState; parameters[8].Value = model.ImageLicence; parameters[9].Value = model.ImageRevenue; parameters[10].Value = model.ImageCompetency; parameters[11].Value = model.Remark; parameters[12].Value = model.IsForbid; parameters[13].Value = model.CollProperty;//煤矿属性 return DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
public bool update(IndustryPlatform.Model.Sys_Colliery coll, List<IndustryPlatform.Model.Sys_FileSave> listModel) { try { lock (this) { StringBuilder strSql = new StringBuilder(); List<string> listSql = new List<string>(); List<SqlParameter[]> listParm = new List<SqlParameter[]>(); strSql = new StringBuilder(); strSql.Append("update Sys_Colliery set "); strSql.Append("CollName=@CollName,"); strSql.Append("OrgCode=@OrgCode,"); strSql.Append("VillageCode=@VillageCode,"); strSql.Append("MineOwner=@MineOwner,"); strSql.Append("MinePhone=@MinePhone,"); strSql.Append("YearOutput=@YearOutput,"); strSql.Append("CollState=@CollState,"); strSql.Append("ImageLicence=@ImageLicence,"); strSql.Append("ImageRevenue=@ImageRevenue,"); strSql.Append("ImageCompetency=@ImageCompetency,"); strSql.Append("Remark=@Remark,"); strSql.Append("IsForbid=@IsForbid,"); strSql.Append("CollProperty=@CollProperty,"); strSql.Append("ParcelCode=@ParcelCode"); strSql.Append(" where CollCode=@CollCode "); SqlParameter[] parameters = { new SqlParameter("@CollCode", SqlDbType.VarChar,20), new SqlParameter("@CollName", SqlDbType.VarChar,50), new SqlParameter("@OrgCode", SqlDbType.VarChar,10), new SqlParameter("@VillageCode", SqlDbType.VarChar,4), new SqlParameter("@MineOwner", SqlDbType.VarChar,20), new SqlParameter("@MinePhone", SqlDbType.VarChar,30), new SqlParameter("@YearOutput", SqlDbType.Decimal,9), new SqlParameter("@CollState", SqlDbType.VarChar,10), new SqlParameter("@ImageLicence", SqlDbType.VarChar,32), new SqlParameter("@ImageRevenue", SqlDbType.VarChar,32), new SqlParameter("@ImageCompetency", SqlDbType.VarChar,32), new SqlParameter("@Remark", SqlDbType.VarChar,200), new SqlParameter("@IsForbid", SqlDbType.VarChar,1), new SqlParameter("@CollProperty",SqlDbType.VarChar,1), new SqlParameter("@ParcelCode",SqlDbType.VarChar,10)}; parameters[0].Value = coll.CollCode; parameters[1].Value = coll.CollName; parameters[2].Value = coll.OrgCode; parameters[3].Value = coll.VillageCode; parameters[4].Value = coll.MineOwner; parameters[5].Value = coll.MinePhone; parameters[6].Value = coll.YearOutput; parameters[7].Value = coll.CollState; parameters[8].Value = coll.ImageLicence; parameters[9].Value = coll.ImageRevenue; parameters[10].Value = coll.ImageCompetency; parameters[11].Value = coll.Remark; parameters[12].Value = coll.IsForbid; parameters[13].Value = coll.CollProperty;//煤矿属性 parameters[14].Value = coll.ParcelCode; listSql.Add(strSql.ToString()); listParm.Add(parameters); foreach (IndustryPlatform.Model.Sys_FileSave model in listModel) { strSql = new StringBuilder(); if ("0" != Getresult("count(*)", "Sys_FileSave", "FileCode='" + model.FileCode + "'")) { strSql.Append("update Sys_FileSave set "); strSql.Append("FileName=@FileName,"); strSql.Append("FilePath=@FilePath,"); strSql.Append("FileSize=@FileSize,"); strSql.Append("FileType=@FileType,"); strSql.Append("FileContent=@FileContent"); strSql.Append(" where FileCode=@FileCode "); SqlParameter[] parameters2 = { new SqlParameter("@FileCode", SqlDbType.VarChar,32), new SqlParameter("@FileName", SqlDbType.VarChar,50), new SqlParameter("@FilePath", SqlDbType.VarChar,200), new SqlParameter("@FileSize", SqlDbType.Decimal,9), new SqlParameter("@FileType", SqlDbType.VarChar,32), new SqlParameter("@FileContent", SqlDbType.VarBinary) }; parameters2[0].Value = model.FileCode; parameters2[1].Value = model.FileName; parameters2[2].Value = model.FilePath; parameters2[3].Value = model.FileSize; parameters2[4].Value = model.FileType; parameters2[5].Value = model.FileContent; listSql.Add(strSql.ToString()); listParm.Add(parameters2); } else { strSql.Append("insert into Sys_FileSave("); strSql.Append("FileCode,FileName,FilePath,FileSize,FileType,FileContent)"); strSql.Append(" values ("); strSql.Append("@FileCode,@FileName,@FilePath,@FileSize,@FileType,@FileContent)"); SqlParameter[] parameters2 = { new SqlParameter("@FileCode", SqlDbType.VarChar,32), new SqlParameter("@FileName", SqlDbType.VarChar,50), new SqlParameter("@FilePath", SqlDbType.VarChar,200), new SqlParameter("@FileSize", SqlDbType.Decimal,9), new SqlParameter("@FileType", SqlDbType.VarChar,32), new SqlParameter("@FileContent", SqlDbType.VarBinary) }; parameters2[0].Value = model.FileCode; parameters2[1].Value = model.FileName; parameters2[2].Value = model.FilePath; parameters2[3].Value = model.FileSize; parameters2[4].Value = model.FileType; parameters2[5].Value = model.FileContent; listSql.Add(strSql.ToString()); listParm.Add(parameters2); } } return DbHelperSQL.ExecuteSqlCake(listSql, listParm); } } catch { return false; } }
public bool Add(IndustryPlatform.Model.Sys_Colliery coll, List<IndustryPlatform.Model.Sys_FileSave> listModel) { try { lock (this) { StringBuilder strSql = new StringBuilder(); List<string> listSql = new List<string>(); List<SqlParameter[]> listParm = new List<SqlParameter[]>(); strSql.Append("insert into Sys_Colliery("); strSql.Append("CollCode,CollName,OrgCode,VillageCode,MineOwner,MinePhone,YearOutput,CollState,ImageLicence,ImageRevenue,ImageCompetency,Remark,IsForbid,CollProperty,ParcelCode)"); strSql.Append(" values ("); strSql.Append("@CollCode,@CollName,@OrgCode,@VillageCode,@MineOwner,@MinePhone,@YearOutput,@CollState,@ImageLicence,@ImageRevenue,@ImageCompetency,@Remark,@IsForbid,@CollProperty,@ParcelCode)"); SqlParameter[] parameters = { new SqlParameter("@CollCode", SqlDbType.VarChar,20), new SqlParameter("@CollName", SqlDbType.VarChar,50), new SqlParameter("@OrgCode", SqlDbType.VarChar,10), new SqlParameter("@VillageCode", SqlDbType.VarChar,4), new SqlParameter("@MineOwner", SqlDbType.VarChar,20), new SqlParameter("@MinePhone", SqlDbType.VarChar,30), new SqlParameter("@YearOutput", SqlDbType.Decimal,9), new SqlParameter("@CollState", SqlDbType.VarChar,10), new SqlParameter("@ImageLicence", SqlDbType.VarChar,32), new SqlParameter("@ImageRevenue", SqlDbType.VarChar,32), new SqlParameter("@ImageCompetency", SqlDbType.VarChar,32), new SqlParameter("@Remark", SqlDbType.VarChar,200), new SqlParameter("@IsForbid", SqlDbType.VarChar,1), new SqlParameter("@CollProperty",SqlDbType.VarChar,1), new SqlParameter("@ParcelCode",SqlDbType.VarChar,10)}; parameters[0].Value = coll.CollCode; parameters[1].Value = coll.CollName; parameters[2].Value = coll.OrgCode; parameters[3].Value = coll.VillageCode; parameters[4].Value = coll.MineOwner; parameters[5].Value = coll.MinePhone; parameters[6].Value = coll.YearOutput; parameters[7].Value = coll.CollState; parameters[8].Value = coll.ImageLicence; parameters[9].Value = coll.ImageRevenue; parameters[10].Value = coll.ImageCompetency; parameters[11].Value = coll.Remark; parameters[12].Value = coll.IsForbid; parameters[13].Value = coll.CollProperty;//煤矿属性 parameters[14].Value = coll.ParcelCode; listSql.Add(strSql.ToString()); listParm.Add(parameters); //保存煤矿最低余额 strSql = new StringBuilder(); strSql.Append("insert into TT_ColieryAccount(CollCode) values (@CollCode)"); SqlParameter[] parameters3 = { new SqlParameter("@CollCode", SqlDbType.VarChar,10)}; parameters3[0].Value = coll.CollCode; listSql.Add(strSql.ToString()); listParm.Add(parameters3); foreach (IndustryPlatform.Model.Sys_FileSave model in listModel) { strSql = new StringBuilder(); strSql.Append("insert into Sys_FileSave("); strSql.Append("FileCode,FileName,FilePath,FileSize,FileType,FileContent)"); strSql.Append(" values ("); strSql.Append("@FileCode,@FileName,@FilePath,@FileSize,@FileType,@FileContent)"); SqlParameter[] parameters2 = { new SqlParameter("@FileCode", SqlDbType.VarChar,32), new SqlParameter("@FileName", SqlDbType.VarChar,50), new SqlParameter("@FilePath", SqlDbType.VarChar,200), new SqlParameter("@FileSize", SqlDbType.Decimal,9), new SqlParameter("@FileType", SqlDbType.VarChar,50), new SqlParameter("@FileContent", SqlDbType.VarBinary) }; parameters2[0].Value = model.FileCode; parameters2[1].Value = model.FileName; parameters2[2].Value = model.FilePath; parameters2[3].Value = model.FileSize; parameters2[4].Value = model.FileType; parameters2[5].Value = model.FileContent; listSql.Add(strSql.ToString()); listParm.Add(parameters2); } return DbHelperSQL.ExecuteSqlCake(listSql, listParm); } } catch { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(IndustryPlatform.Model.Sys_Colliery model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_Colliery("); strSql.Append("CollieryID,CollCode,CollName,OrgCode,VillageCode,MineOwner,MinePhone,YearOutput,CollState,ImageLicence,LicenceImageType,ImageRevenue,RevenueImageType,ImageCompetency,CompetencyImageType,Remark,IsForbid,CollProperty)"); strSql.Append(" values ("); strSql.Append("@CollCode,@CollName,@OrgCode,@VillageCode,@MineOwner,@MinePhone,@YearOutput,@CollState,@ImageLicence,@ImageRevenue,@ImageCompetency,@Remark,@IsForbid,@CollProperty)"); SqlParameter[] parameters = { new SqlParameter("@CollCode", SqlDbType.VarChar,20), new SqlParameter("@CollName", SqlDbType.VarChar,50), new SqlParameter("@OrgCode", SqlDbType.Decimal,9), new SqlParameter("@VillageCode", SqlDbType.VarChar,4), new SqlParameter("@MineOwner", SqlDbType.VarChar,20), new SqlParameter("@MinePhone", SqlDbType.VarChar,30), new SqlParameter("@YearOutput", SqlDbType.Decimal,9), new SqlParameter("@CollState", SqlDbType.VarChar,10), new SqlParameter("@ImageLicence", SqlDbType.VarChar,32), new SqlParameter("@ImageRevenue", SqlDbType.VarChar,32), new SqlParameter("@ImageCompetency", SqlDbType.VarChar,32), new SqlParameter("@Remark", SqlDbType.VarChar,200), new SqlParameter("@IsForbid", SqlDbType.VarChar,1), new SqlParameter("@CollProperty",SqlDbType.VarChar,1)}; parameters[0].Value = model.CollCode; parameters[1].Value = model.CollName; parameters[2].Value = model.OrgCode; parameters[3].Value = model.VillageCode; parameters[4].Value = model.MineOwner; parameters[5].Value = model.MinePhone; parameters[6].Value = model.YearOutput; parameters[7].Value = model.CollState; parameters[8].Value = model.ImageLicence; parameters[9].Value = model.ImageRevenue; parameters[10].Value = model.ImageCompetency; parameters[11].Value = model.Remark; parameters[12].Value = model.IsForbid; parameters[13].Value = model.CollProperty;//煤矿属性 return DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
public bool Add(IndustryPlatform.Model.Sys_Colliery coll, List<IndustryPlatform.Model.Sys_FileSave> listModel) { return dal.Add(coll, listModel); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(IndustryPlatform.Model.Sys_Colliery model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(IndustryPlatform.Model.Sys_Colliery model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(IndustryPlatform.Model.SYS_DictionaryEntity model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(IndustryPlatform.Model.SYS_DictionaryEntity model) { return dal.Update(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(IndustryPlatform.Model.SYS_DictionaryEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sys_Dictionary set "); strSql.Append("BusinName=@BusinName,"); strSql.Append("DisplayOrder=@DisplayOrder,"); strSql.Append("IsForbid=@IsForbid"); strSql.Append(" where BusinID=@BusinID and BusinTypeID=@BusinTypeID "); SqlParameter[] parameters = { new SqlParameter("@BusinID", SqlDbType.VarChar,10), new SqlParameter("@BusinName", SqlDbType.NVarChar,50), new SqlParameter("@BusinTypeID", SqlDbType.VarChar,10), new SqlParameter("@DisplayOrder", SqlDbType.Decimal,5), new SqlParameter("@IsForbid", SqlDbType.VarChar,1)}; parameters[0].Value = model.BusinID; parameters[1].Value = model.BusinName; parameters[2].Value = model.BusinTypeID; parameters[3].Value = model.DisplayOrder; parameters[4].Value = model.IsForbid; try { DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); return true; } catch(Exception ex) { return false; } }