/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MSCD.Model.LayerCatalog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into b_LayerCatalog(");
strSql.Append("typeId,layerName,layerCaption)");
strSql.Append(" values (");
strSql.Append("@typeId,@layerName,@layerCaption)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@typeId", SqlDbType.Int,4),
new SqlParameter("@layerName", SqlDbType.VarChar,50),
new SqlParameter("@layerCaption", SqlDbType.VarChar,50)}
;
parameters[0].Value = model.typeId;
parameters[1].Value = model.layerName;
parameters[2].Value = model.layerCaption;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MSCD.Model.EqptImage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into b_EqptImage(");
strSql.Append("SmId,LayerName,ImageName,Image)");
strSql.Append(" values (");
strSql.Append("@SmId,@LayerName,@ImageName,@Image)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@SmId", SqlDbType.Int,4),
new SqlParameter("@LayerName", SqlDbType.VarChar,50),
new SqlParameter("@ImageName", SqlDbType.VarChar,255),
new SqlParameter("@Image", SqlDbType.VarBinary)};
parameters[0].Value = model.SmId;
parameters[1].Value = model.LayerName;
parameters[2].Value = model.ImageName;
parameters[3].Value = model.Image;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MSCD.Model.EqptMaintain model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into b_EqptMaintain(");
strSql.Append("SmId,LayerName,Name,Department,EqptName,RecordDate,MaintainDate,NextMaintainDate,MaintainType,Maintainer,Checker,Reason,Process,Result,CheckOpinion)");
strSql.Append(" values (");
strSql.Append("@SmId,@LayerName,@Name,@Department,@EqptName,@RecordDate,@MaintainDate,@NextMaintainDate,@MaintainType,@Maintainer,@Checker,@Reason,@Process,@Result,@CheckOpinion)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@SmId", SqlDbType.Int,4),
new SqlParameter("@LayerName", SqlDbType.VarChar,50),
new SqlParameter("@Name", SqlDbType.VarChar,200),
new SqlParameter("@Department", SqlDbType.VarChar,200),
new SqlParameter("@EqptName", SqlDbType.VarChar,200),
new SqlParameter("@RecordDate", SqlDbType.Date,3),
new SqlParameter("@MaintainDate", SqlDbType.Date,3),
new SqlParameter("@NextMaintainDate", SqlDbType.Date,3),
new SqlParameter("@MaintainType", SqlDbType.Int,4),
new SqlParameter("@Maintainer", SqlDbType.VarChar,200),
new SqlParameter("@Checker", SqlDbType.VarChar,200),
new SqlParameter("@Reason", SqlDbType.VarChar,500),
new SqlParameter("@Process", SqlDbType.VarChar,500),
new SqlParameter("@Result", SqlDbType.VarChar,500),
new SqlParameter("@CheckOpinion", SqlDbType.VarChar,500)};
parameters[0].Value = model.SmId;
parameters[1].Value = model.LayerName;
parameters[2].Value = model.Name;
parameters[3].Value = model.Department;
parameters[4].Value = model.EqptName;
parameters[5].Value = model.RecordDate;
parameters[6].Value = model.MaintainDate;
parameters[7].Value = model.NextMaintainDate;
parameters[8].Value = model.MaintainType;
parameters[9].Value = model.Maintainer;
parameters[10].Value = model.Checker;
parameters[11].Value = model.Reason;
parameters[12].Value = model.Process;
parameters[13].Value = model.Result;
parameters[14].Value = model.CheckOpinion;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MSCD.Model.LayerType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into b_LayerType(");
strSql.Append("Name)");
strSql.Append(" values (");
strSql.Append("@Name)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.VarChar,50)};
parameters[0].Value = model.Name;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MSCD.Model.Config model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into b_Config(");
strSql.Append("name,info)");
strSql.Append(" values (");
strSql.Append("@name,@info)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@name", SqlDbType.VarChar,50),
new SqlParameter("@info", SqlDbType.VarChar)};
parameters[0].Value = model.name;
parameters[1].Value = model.info;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MSCD.Model.User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into b_User(");
strSql.Append("Username,Password,Name,Department,Tel,Phone,Remark,Type)");
strSql.Append(" values (");
strSql.Append("@Username,@Password,@Name,@Department,@Tel,@Phone,@Remark,@Type)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Username", SqlDbType.VarChar,50),
new SqlParameter("@Password", SqlDbType.VarChar,50),
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@Department", SqlDbType.VarChar,50),
new SqlParameter("@Tel", SqlDbType.VarChar,50),
new SqlParameter("@Phone", SqlDbType.VarChar,50),
new SqlParameter("@Remark", SqlDbType.VarChar,200),
new SqlParameter("@Type", SqlDbType.Int,4)};
parameters[0].Value = model.Username;
parameters[1].Value = model.Password;
parameters[2].Value = model.Name;
parameters[3].Value = model.Department;
parameters[4].Value = model.Tel;
parameters[5].Value = model.Phone;
parameters[6].Value = model.Remark;
parameters[7].Value = model.Type;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MSCD.Model.LayerType model)
{
return dal.Add(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MSCD.Model.EqptAttachment model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MSCD.Model.LayerType model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MSCD.Model.Config model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MSCD.Model.EqptAttachment model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MSCD.Model.Config model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MSCD.Model.LayerType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update b_LayerType set ");
strSql.Append("Name=@Name");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.Name;
parameters[1].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MSCD.Model.EqptMaintain model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MSCD.Model.LayerCatalog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update b_LayerCatalog set ");
strSql.Append("typeId=@typeId,");
strSql.Append("layerName=@layerName");
strSql.Append("layerCaption=@layerCaption");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@typeId", SqlDbType.Int,4),
new SqlParameter("@layerName", SqlDbType.VarChar,50),
new SqlParameter("@layerCaption", SqlDbType.VarChar,50),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.typeId;
parameters[1].Value = model.layerName;
parameters[1].Value = model.layerCaption;
parameters[3].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MSCD.Model.EqptImage model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MSCD.Model.EqptImage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update b_EqptImage set ");
strSql.Append("SmId=@SmId,");
strSql.Append("LayerName=@LayerName,");
strSql.Append("ImageName=@ImageName,");
strSql.Append("Image=@Image");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@SmId", SqlDbType.Int,4),
new SqlParameter("@LayerName", SqlDbType.VarChar,50),
new SqlParameter("@ImageName", SqlDbType.VarChar,255),
new SqlParameter("@Image", SqlDbType.VarBinary),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.SmId;
parameters[1].Value = model.LayerName;
parameters[2].Value = model.ImageName;
parameters[3].Value = model.Image;
parameters[4].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MSCD.Model.Config model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update b_Config set ");
strSql.Append("name=@name,");
strSql.Append("info=@info");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@name", SqlDbType.VarChar,50),
new SqlParameter("@info", SqlDbType.VarChar),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.name;
parameters[1].Value = model.info;
parameters[2].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MSCD.Model.User model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MSCD.Model.User model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MSCD.Model.LayerCatalog model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MSCD.Model.LayerCatalog model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MSCD.Model.EqptImage model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MSCD.Model.User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update b_User set ");
strSql.Append("Username=@Username,");
strSql.Append("Password=@Password,");
strSql.Append("Name=@Name,");
strSql.Append("Department=@Department,");
strSql.Append("Tel=@Tel,");
strSql.Append("Phone=@Phone,");
strSql.Append("Remark=@Remark,");
strSql.Append("Type=@Type");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Username", SqlDbType.VarChar,50),
new SqlParameter("@Password", SqlDbType.VarChar,50),
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@Department", SqlDbType.VarChar,50),
new SqlParameter("@Tel", SqlDbType.VarChar,50),
new SqlParameter("@Phone", SqlDbType.VarChar,50),
new SqlParameter("@Remark", SqlDbType.VarChar,200),
new SqlParameter("@Type", SqlDbType.Int,4),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.Username;
parameters[1].Value = model.Password;
parameters[2].Value = model.Name;
parameters[3].Value = model.Department;
parameters[4].Value = model.Tel;
parameters[5].Value = model.Phone;
parameters[6].Value = model.Remark;
parameters[7].Value = model.Type;
parameters[8].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MSCD.Model.EqptMaintain model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update b_EqptMaintain set ");
strSql.Append("SmId=@SmId,");
strSql.Append("LayerName=@LayerName,");
strSql.Append("Name=@Name,");
strSql.Append("Department=@Department,");
strSql.Append("EqptName=@EqptName,");
strSql.Append("RecordDate=@RecordDate,");
strSql.Append("MaintainDate=@MaintainDate,");
strSql.Append("NextMaintainDate=@NextMaintainDate,");
strSql.Append("MaintainType=@MaintainType,");
strSql.Append("Maintainer=@Maintainer,");
strSql.Append("Checker=@Checker,");
strSql.Append("Reason=@Reason,");
strSql.Append("Process=@Process,");
strSql.Append("Result=@Result,");
strSql.Append("CheckOpinion=@CheckOpinion");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@SmId", SqlDbType.Int,4),
new SqlParameter("@LayerName", SqlDbType.VarChar,50),
new SqlParameter("@Name", SqlDbType.VarChar,200),
new SqlParameter("@Department", SqlDbType.VarChar,200),
new SqlParameter("@EqptName", SqlDbType.VarChar,200),
new SqlParameter("@RecordDate", SqlDbType.Date,3),
new SqlParameter("@MaintainDate", SqlDbType.Date,3),
new SqlParameter("@NextMaintainDate", SqlDbType.Date,3),
new SqlParameter("@MaintainType", SqlDbType.Int,4),
new SqlParameter("@Maintainer", SqlDbType.VarChar,200),
new SqlParameter("@Checker", SqlDbType.VarChar,200),
new SqlParameter("@Reason", SqlDbType.VarChar,500),
new SqlParameter("@Process", SqlDbType.VarChar,500),
new SqlParameter("@Result", SqlDbType.VarChar,500),
new SqlParameter("@CheckOpinion", SqlDbType.VarChar,500),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.SmId;
parameters[1].Value = model.LayerName;
parameters[2].Value = model.Name;
parameters[3].Value = model.Department;
parameters[4].Value = model.EqptName;
parameters[5].Value = model.RecordDate;
parameters[6].Value = model.MaintainDate;
parameters[7].Value = model.NextMaintainDate;
parameters[8].Value = model.MaintainType;
parameters[9].Value = model.Maintainer;
parameters[10].Value = model.Checker;
parameters[11].Value = model.Reason;
parameters[12].Value = model.Process;
parameters[13].Value = model.Result;
parameters[14].Value = model.CheckOpinion;
parameters[15].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MSCD.Model.EqptMaintain model)
{
return dal.Update(model);
}
