/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ECAMSDataAccess.OCVCheckInterfaceModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update OCVCheckInterface set ");
strSql.Append("ProductFrameCode=@ProductFrameCode,");
strSql.Append("CheckType=@CheckType,");
strSql.Append("CorePosition=@CorePosition,");
strSql.Append("HasCore=@HasCore,");
strSql.Append("CoreStatus=@CoreStatus,");
strSql.Append("ReportTime=@ReportTime,");
strSql.Append("HandleStatus=@HandleStatus,");
strSql.Append("Remarks=@Remarks");
strSql.Append(" where CheckInterfaceID=@CheckInterfaceID ");
SqlParameter[] parameters =
{
new SqlParameter("@ProductFrameCode", SqlDbType.NVarChar, 50),
new SqlParameter("@CheckType", SqlDbType.NVarChar, 50),
new SqlParameter("@CorePosition", SqlDbType.NVarChar, 50),
new SqlParameter("@HasCore", SqlDbType.Int, 4),
new SqlParameter("@CoreStatus", SqlDbType.Int, 4),
new SqlParameter("@ReportTime", SqlDbType.DateTime),
new SqlParameter("@HandleStatus", SqlDbType.Int, 4),
new SqlParameter("@Remarks", SqlDbType.NVarChar, 100),
new SqlParameter("@CheckInterfaceID", SqlDbType.Int, 4)
};
parameters[0].Value = model.ProductFrameCode;
parameters[1].Value = model.CheckType;
parameters[2].Value = model.CorePosition;
parameters[3].Value = model.HasCore;
parameters[4].Value = model.CoreStatus;
parameters[5].Value = model.ReportTime;
parameters[6].Value = model.HandleStatus;
parameters[7].Value = model.Remarks;
parameters[8].Value = model.CheckInterfaceID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ECAMSDataAccess.OCVCheckInterfaceModel DataRowToModel(DataRow row)
{
ECAMSDataAccess.OCVCheckInterfaceModel model = new ECAMSDataAccess.OCVCheckInterfaceModel();
if (row != null)
{
if (row["CheckInterfaceID"] != null && row["CheckInterfaceID"].ToString() != "")
{
model.CheckInterfaceID = int.Parse(row["CheckInterfaceID"].ToString());
}
if (row["ProductFrameCode"] != null)
{
model.ProductFrameCode = row["ProductFrameCode"].ToString();
}
if (row["CheckType"] != null)
{
model.CheckType = row["CheckType"].ToString();
}
if (row["CorePosition"] != null)
{
model.CorePosition = row["CorePosition"].ToString();
}
if (row["HasCore"] != null && row["HasCore"].ToString() != "")
{
model.HasCore = int.Parse(row["HasCore"].ToString());
}
if (row["CoreStatus"] != null && row["CoreStatus"].ToString() != "")
{
model.CoreStatus = int.Parse(row["CoreStatus"].ToString());
}
if (row["ReportTime"] != null && row["ReportTime"].ToString() != "")
{
model.ReportTime = DateTime.Parse(row["ReportTime"].ToString());
}
if (row["HandleStatus"] != null && row["HandleStatus"].ToString() != "")
{
model.HandleStatus = int.Parse(row["HandleStatus"].ToString());
}
if (row["Remarks"] != null)
{
model.Remarks = row["Remarks"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ECAMSDataAccess.OCVCheckInterfaceModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OCVCheckInterface(");
strSql.Append("CheckInterfaceID,ProductFrameCode,CheckType,CorePosition,HasCore,CoreStatus,ReportTime,HandleStatus,Remarks)");
strSql.Append(" values (");
strSql.Append("@CheckInterfaceID,@ProductFrameCode,@CheckType,@CorePosition,@HasCore,@CoreStatus,@ReportTime,@HandleStatus,@Remarks)");
SqlParameter[] parameters =
{
new SqlParameter("@CheckInterfaceID", SqlDbType.Int, 4),
new SqlParameter("@ProductFrameCode", SqlDbType.NVarChar, 50),
new SqlParameter("@CheckType", SqlDbType.NVarChar, 50),
new SqlParameter("@CorePosition", SqlDbType.NVarChar, 50),
new SqlParameter("@HasCore", SqlDbType.Int, 4),
new SqlParameter("@CoreStatus", SqlDbType.Int, 4),
new SqlParameter("@ReportTime", SqlDbType.DateTime),
new SqlParameter("@HandleStatus", SqlDbType.Int, 4),
new SqlParameter("@Remarks", SqlDbType.NVarChar, 100)
};
parameters[0].Value = model.CheckInterfaceID;
parameters[1].Value = model.ProductFrameCode;
parameters[2].Value = model.CheckType;
parameters[3].Value = model.CorePosition;
parameters[4].Value = model.HasCore;
parameters[5].Value = model.CoreStatus;
parameters[6].Value = model.ReportTime;
parameters[7].Value = model.HandleStatus;
parameters[8].Value = model.Remarks;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ECAMSDataAccess.OCVCheckInterfaceModel GetModel(int CheckInterfaceID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 CheckInterfaceID,ProductFrameCode,CheckType,CorePosition,HasCore,CoreStatus,ReportTime,HandleStatus,Remarks from OCVCheckInterface ");
strSql.Append(" where CheckInterfaceID=@CheckInterfaceID ");
SqlParameter[] parameters =
{
new SqlParameter("@CheckInterfaceID", SqlDbType.Int, 4)
};
parameters[0].Value = CheckInterfaceID;
ECAMSDataAccess.OCVCheckInterfaceModel model = new ECAMSDataAccess.OCVCheckInterfaceModel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
