/// <summary>
/// 增加一条数据
/// </summary>
public SqlCommand AddCommand(Common.Model.MouldingDefectSetting_Model model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MouldingDefectSetting(");
strSql.Append("defectCodeID,defectCode,defectDescription,partNumber,model,jigNo,machineID,userName,dateTime,remarks)");
strSql.Append(" values (");
strSql.Append("@defectCodeID,@defectCode,@defectDescription,@partNumber,@model,@jigNo,@machineID,@userName,@dateTime,@remarks)");
SqlParameter[] parameters =
{
new SqlParameter("@defectCodeID", SqlDbType.VarChar, 50),
new SqlParameter("@defectCode", SqlDbType.VarChar, 50),
new SqlParameter("@defectDescription", SqlDbType.VarChar, 200),
new SqlParameter("@partNumber", SqlDbType.VarChar, 50),
new SqlParameter("@model", SqlDbType.VarChar, 50),
new SqlParameter("@jigNo", SqlDbType.VarChar, 50),
new SqlParameter("@machineID", SqlDbType.VarChar, 8),
new SqlParameter("@userName", SqlDbType.VarChar, 50),
new SqlParameter("@dateTime", SqlDbType.SmallDateTime),
new SqlParameter("@remarks", SqlDbType.VarChar, 500)
};
DBHelp.Reports.LogFile.DebugLog("AUTOCODE", "NameSpace:Common.DAL", "Class:MouldingDefectSetting_DAL", "Function: public SqlCommand AddCommand(Common.Model.MouldingDefectSetting_Model model)"+ "TableName:MouldingDefectSetting", ";defectCodeID = " + (model.defectCodeID == null ? "" : model.defectCodeID.ToString()) + ";defectCode = " + (model.defectCode == null ? "" : model.defectCode.ToString()) + ";defectDescription = " + (model.defectDescription == null ? "" : model.defectDescription.ToString()) + ";partNumber = " + (model.partNumber == null ? "" : model.partNumber.ToString()) + ";model = " + (model.model == null ? "" : model.model.ToString()) + ";jigNo = " + (model.jigNo == null ? "" : model.jigNo.ToString()) + ";machineID = " + (model.machineID == null ? "" : model.machineID.ToString()) + ";userName = "******"" : model.userName.ToString()) + ";dateTime = " + (model.dateTime == null ? "" : model.dateTime.ToString()) + ";remarks = " + (model.remarks == null ? "" : model.remarks.ToString()) + "");
parameters[0].Value = model.defectCodeID == null ? (object)DBNull.Value : model.defectCodeID;
parameters[1].Value = model.defectCode == null ? (object)DBNull.Value : model.defectCode;
parameters[2].Value = model.defectDescription == null ? (object)DBNull.Value : model.defectDescription;
parameters[3].Value = model.partNumber == null ? (object)DBNull.Value : model.partNumber;
parameters[4].Value = model.model == null ? (object)DBNull.Value : model.model;
parameters[5].Value = model.jigNo == null ? (object)DBNull.Value : model.jigNo;
parameters[6].Value = model.machineID == null ? (object)DBNull.Value : model.machineID;
parameters[7].Value = model.userName == null ? (object)DBNull.Value : model.userName;
parameters[8].Value = model.dateTime == null ? (object)DBNull.Value : model.dateTime;
parameters[9].Value = model.remarks == null ? (object)DBNull.Value : model.remarks;
return(DBHelp.SqlDB.generateCommand(strSql.ToString(), parameters));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Common.Model.MouldingDefectSetting_Model model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update MouldingDefectSetting set ");
strSql.Append("defectCodeID=@defectCodeID,");
strSql.Append("defectCode=@defectCode,");
strSql.Append("defectDescription=@defectDescription,");
strSql.Append("partNumber=@partNumber,");
strSql.Append("model=@model,");
strSql.Append("jigNo=@jigNo,");
strSql.Append("machineID=@machineID,");
strSql.Append("userName=@userName,");
strSql.Append("dateTime=@dateTime,");
strSql.Append("remarks=@remarks");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@defectCodeID", SqlDbType.VarChar, 50),
new SqlParameter("@defectCode", SqlDbType.VarChar, 50),
new SqlParameter("@defectDescription", SqlDbType.VarChar, 200),
new SqlParameter("@partNumber", SqlDbType.VarChar, 50),
new SqlParameter("@model", SqlDbType.VarChar, 50),
new SqlParameter("@jigNo", SqlDbType.VarChar, 50),
new SqlParameter("@machineID", SqlDbType.VarChar, 8),
new SqlParameter("@userName", SqlDbType.VarChar, 50),
new SqlParameter("@dateTime", SqlDbType.SmallDateTime),
new SqlParameter("@remarks", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.defectCodeID == null ? (object)DBNull.Value : model.defectCodeID;
parameters[1].Value = model.defectCode == null ? (object)DBNull.Value : model.defectCode;
parameters[2].Value = model.defectDescription == null ? (object)DBNull.Value : model.defectDescription;
parameters[3].Value = model.partNumber == null ? (object)DBNull.Value : model.partNumber;
parameters[4].Value = model.model == null ? (object)DBNull.Value : model.model;
parameters[5].Value = model.jigNo == null ? (object)DBNull.Value : model.jigNo;
parameters[6].Value = model.machineID == null ? (object)DBNull.Value : model.machineID;
parameters[7].Value = model.userName == null ? (object)DBNull.Value : model.userName;
parameters[8].Value = model.dateTime == null ? (object)DBNull.Value : model.dateTime;
parameters[9].Value = model.remarks == null ? (object)DBNull.Value : model.remarks;
DBHelp.Reports.LogFile.DebugLog("AUTOCODE", "NameSpace:Common.DAL", "Class:MouldingDefectSetting_DAL", "Function: public bool Update(Common.Model.MouldingDefectSetting_Model model)"+ "TableName:MouldingDefectSetting", ";defectCodeID = " + (model.defectCodeID == null ? "" : model.defectCodeID.ToString()) + ";defectCode = " + (model.defectCode == null ? "" : model.defectCode.ToString()) + ";defectDescription = " + (model.defectDescription == null ? "" : model.defectDescription.ToString()) + ";partNumber = " + (model.partNumber == null ? "" : model.partNumber.ToString()) + ";model = " + (model.model == null ? "" : model.model.ToString()) + ";jigNo = " + (model.jigNo == null ? "" : model.jigNo.ToString()) + ";machineID = " + (model.machineID == null ? "" : model.machineID.ToString()) + ";userName = "******"" : model.userName.ToString()) + ";dateTime = " + (model.dateTime == null ? "" : model.dateTime.ToString()) + ";remarks = " + (model.remarks == null ? "" : model.remarks.ToString()) + "");
int rows = DBHelp.SqlDB.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Common.Model.MouldingDefectSetting_Model GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 defectCodeID,defectCode,defectDescription,partNumber,model,jigNo,machineID,userName,dateTime,remarks from MouldingDefectSetting ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
DBHelp.Reports.LogFile.DebugLog("AUTOCODE", "NameSpace:Common.DAL", "Class:MouldingDefectSetting_DAL", "Function: public Common.Model.MouldingDefectSetting_Model GetModel()"+ "TableName:MouldingDefectSetting", "");
Common.Model.MouldingDefectSetting_Model model = new Common.Model.MouldingDefectSetting_Model();
DataSet ds = DBHelp.SqlDB.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.defectCodeID = ds.Tables[0].Rows[0]["defectCodeID"].ToString();
model.defectCode = ds.Tables[0].Rows[0]["defectCode"].ToString();
model.defectDescription = ds.Tables[0].Rows[0]["defectDescription"].ToString();
model.partNumber = ds.Tables[0].Rows[0]["partNumber"].ToString();
model.model = ds.Tables[0].Rows[0]["model"].ToString();
model.jigNo = ds.Tables[0].Rows[0]["jigNo"].ToString();
model.machineID = ds.Tables[0].Rows[0]["machineID"].ToString();
model.userName = ds.Tables[0].Rows[0]["userName"].ToString();
if (ds.Tables[0].Rows[0]["dateTime"].ToString() != "")
{
model.dateTime = DateTime.Parse(ds.Tables[0].Rows[0]["dateTime"].ToString());
}
model.remarks = ds.Tables[0].Rows[0]["remarks"].ToString();
return(model);
}
else
{
return(null);
}
}
