/// <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));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public IndustryPlatform.Model.Sys_Colliery GetModel(string CollCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select CollCode,CollName,OrgCode,VillageCode,MineOwner,MinePhone,YearOutput,CollState,ImageLicence,ImageRevenue,ImageCompetency,Remark,IsForbid,CollProperty,ParcelCode from Sys_Colliery ");
strSql.Append(" where CollCode=@CollCode ");
SqlParameter[] parameters =
{
new SqlParameter("@CollCode", SqlDbType.NVarChar)
};
parameters[0].Value = CollCode;
IndustryPlatform.Model.Sys_Colliery model = new IndustryPlatform.Model.Sys_Colliery();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.CollCode = ds.Tables[0].Rows[0]["CollCode"].ToString();
model.CollName = ds.Tables[0].Rows[0]["CollName"].ToString();
if (ds.Tables[0].Rows[0]["OrgCode"].ToString() != "")
{
model.OrgCode = ds.Tables[0].Rows[0]["OrgCode"].ToString();
}
model.VillageCode = ds.Tables[0].Rows[0]["VillageCode"].ToString();
model.MineOwner = ds.Tables[0].Rows[0]["MineOwner"].ToString();
model.MinePhone = ds.Tables[0].Rows[0]["MinePhone"].ToString();
if (ds.Tables[0].Rows[0]["YearOutput"].ToString() != "")
{
model.YearOutput = decimal.Parse(ds.Tables[0].Rows[0]["YearOutput"].ToString());
}
model.CollState = ds.Tables[0].Rows[0]["CollState"].ToString();
if (ds.Tables[0].Rows[0]["ImageLicence"].ToString() != "")
{
model.ImageLicence = ds.Tables[0].Rows[0]["ImageLicence"].ToString();
}
if (ds.Tables[0].Rows[0]["ImageRevenue"].ToString() != "")
{
model.ImageRevenue = ds.Tables[0].Rows[0]["ImageRevenue"].ToString();
}
if (ds.Tables[0].Rows[0]["ImageCompetency"].ToString() != "")
{
model.ImageCompetency = ds.Tables[0].Rows[0]["ImageCompetency"].ToString();
}
if (ds.Tables[0].Rows[0]["CollProperty"].ToString() != "")
{
model.CollProperty = ds.Tables[0].Rows[0]["CollProperty"].ToString();
}
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
model.IsForbid = ds.Tables[0].Rows[0]["IsForbid"].ToString();
model.ParcelCode = ds.Tables[0].Rows[0]["ParcelCode"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <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));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public IndustryPlatform.Model.Sys_Colliery GetModel(string CollCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select CollCode,CollName,OrgCode,VillageCode,MineOwner,MinePhone,YearOutput,CollState,ImageLicence,ImageRevenue,ImageCompetency,Remark,IsForbid,CollProperty,ParcelCode from Sys_Colliery ");
strSql.Append(" where CollCode=@CollCode ");
SqlParameter[] parameters = {
new SqlParameter("@CollCode", SqlDbType.NVarChar)};
parameters[0].Value = CollCode;
IndustryPlatform.Model.Sys_Colliery model = new IndustryPlatform.Model.Sys_Colliery();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.CollCode = ds.Tables[0].Rows[0]["CollCode"].ToString();
model.CollName = ds.Tables[0].Rows[0]["CollName"].ToString();
if (ds.Tables[0].Rows[0]["OrgCode"].ToString() != "")
{
model.OrgCode = ds.Tables[0].Rows[0]["OrgCode"].ToString();
}
model.VillageCode = ds.Tables[0].Rows[0]["VillageCode"].ToString();
model.MineOwner = ds.Tables[0].Rows[0]["MineOwner"].ToString();
model.MinePhone = ds.Tables[0].Rows[0]["MinePhone"].ToString();
if (ds.Tables[0].Rows[0]["YearOutput"].ToString() != "")
{
model.YearOutput = decimal.Parse(ds.Tables[0].Rows[0]["YearOutput"].ToString());
}
model.CollState = ds.Tables[0].Rows[0]["CollState"].ToString();
if (ds.Tables[0].Rows[0]["ImageLicence"].ToString() != "")
{
model.ImageLicence = ds.Tables[0].Rows[0]["ImageLicence"].ToString();
}
if (ds.Tables[0].Rows[0]["ImageRevenue"].ToString() != "")
{
model.ImageRevenue = ds.Tables[0].Rows[0]["ImageRevenue"].ToString();
}
if (ds.Tables[0].Rows[0]["ImageCompetency"].ToString() != "")
{
model.ImageCompetency =ds.Tables[0].Rows[0]["ImageCompetency"].ToString();
}
if (ds.Tables[0].Rows[0]["CollProperty"].ToString() != "")
{
model.CollProperty = ds.Tables[0].Rows[0]["CollProperty"].ToString();
}
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
model.IsForbid = ds.Tables[0].Rows[0]["IsForbid"].ToString();
model.ParcelCode = ds.Tables[0].Rows[0]["ParcelCode"].ToString();
return model;
}
else
{
return null;
}
}
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);
}
}
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);
}
}
