public SqlCommand add(MouldingMachineStatus_Model _model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MouldingMachineStatus(");
strSql.Append("MachineID,Day,Shif,MachineStatus,OEEStatus,StartTime,EndTime,PartNo,UserID,Remark) ");
strSql.Append(" values (");
strSql.Append("@MachineID,@Day,@Shif,@MachineStatus,@OEEStatus,@StartTime,@EndTime,@PartNo,@UserID,@Remark)");
SqlParameter[] parameters =
{
new SqlParameter("@MachineID", SqlDbType.VarChar, 50),
new SqlParameter("@Day", SqlDbType.DateTime2, 8),
new SqlParameter("@Shif", SqlDbType.VarChar, 50),
new SqlParameter("@MachineStatus", SqlDbType.VarChar, 50),
new SqlParameter("@OEEStatus", SqlDbType.VarChar, 50),
new SqlParameter("@StartTime", SqlDbType.DateTime2, 8),
new SqlParameter("@EndTime", SqlDbType.DateTime2, 8),
new SqlParameter("@PartNo", SqlDbType.VarChar, 50),
new SqlParameter("@UserID", SqlDbType.VarChar, 50),
new SqlParameter("@Remark", SqlDbType.VarChar, 50)
};
parameters[0].Value = _model.machineID == null ? (object)DBNull.Value : _model.machineID;
parameters[1].Value = _model.day == null ? (object)DBNull.Value : _model.day;
parameters[2].Value = _model.shift == null ? (object)DBNull.Value : _model.shift;
parameters[3].Value = _model.machinestatus == null ? (object)DBNull.Value : _model.machinestatus;
parameters[4].Value = _model.oeestatus == null ? (object)DBNull.Value : _model.oeestatus;
parameters[5].Value = _model.starttime == null ? (object)DBNull.Value : _model.starttime;
parameters[6].Value = _model.endtime == null ? (object)DBNull.Value : _model.endtime;
parameters[7].Value = _model.partno == null ? (object)DBNull.Value : _model.partno;
parameters[8].Value = _model.userid == null ? (object)DBNull.Value : _model.userid;
parameters[9].Value = _model.remark == null ? (object)DBNull.Value : _model.remark;
return(DBHelp.SqlDB.generateCommand(strSql.ToString(), parameters));
}
public DataSet endtimesearchandupdate(MouldingMachineStatus_Model _model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select MachineID,Day,Shif,MachineStatus,OEEStatus,StartTime,EndTime,PartNo,UserID,Remark ");
strSql.Append(" FROM MouldingMachineStatus ");
strSql.Append(" where MachineID = " + _model.machineID);
strSql.Append(" and EndTime is NULL order by StartTime ");
return(DBHelp.SqlDB.Query(strSql.ToString()));
}
public bool endtimesearchandupdate(MouldingMachineStatus_Model _model)
{
MouldingMachineStatus_Model objmachine = new MouldingMachineStatus_Model();
DataSet ds = dal.endtimesearchandupdate(_model);
if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
return(false);
}
else
{
return(dal.update(ds.Tables[0].Rows[0]["MachineID"].ToString(), _model.starttime));
}
}
public SqlCommand add(MouldingMachineStatus_Model _model)
{
return(dal.add(_model));
}
