/// <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("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected]");
strSql.Append(" where [email protected] ");
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("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected]");//煤矿属性
strSql.Append(" where [email protected] ");
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("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected]");
strSql.Append(" where [email protected] ");
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("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected]");
strSql.Append(" where [email protected] ");
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("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected]");
strSql.Append(" where [email protected] and [email protected] ");
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; }
}
