/// <summary>
/// 添加工艺
/// </summary>
public int AddOper(OperEntity Oper)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbOper([OperID],[OperNote],[DayTime],[WeekTime],[MonthTime],UpdateTime,Remark,UpdateBy)");
strSql.Append(" values ");
strSql.Append("(@OperID,@OperNote,@DayTime,@WeekTime,@MonthTime,@UpdateTime,@UpdateBy,@Remark)");
strSql.Append(";SELECT @@IDENTITY"); //返回插入用户的主键
SqlParameter[] paras =
{
new SqlParameter("@OperID", SqlDbType.VarChar, 50),
new SqlParameter("@OperNote", SqlDbType.VarChar, 50),
new SqlParameter("@DayTime", SqlDbType.Decimal),
new SqlParameter("@WeekTime", SqlDbType.Decimal),
new SqlParameter("@MonthTime", SqlDbType.Decimal),
new SqlParameter("@Remark", SqlDbType.NVarChar, 100),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@UpdateBy", SqlDbType.NVarChar, 100)
};
paras[0].Value = Oper.OperID;
paras[1].Value = Oper.OperNote;
paras[2].Value = Oper.DayTime;
paras[3].Value = Oper.WeekTime;
paras[4].Value = Oper.MonthTime;
paras[5].Value = Oper.Remark;
paras[6].Value = Oper.UpdateTime;
paras[7].Value = Oper.UpdateBy;
return(Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.connStr, CommandType.Text, strSql.ToString(), paras)));
}
/// <summary>
/// 新增工序操作
/// </summary>
/// <returns></returns>
public ActionResult AddOper()
{
try
{
UserEntity uInfo = ViewData["Account"] as UserEntity;
OperEntity oper = new OperEntity();
oper.OperID = int.Parse(Request["FoperID"]);
oper.UpdateTime = DateTime.Now;
oper.UpdateBy = uInfo.AccountName;
oper.OperNote = Request["OperNote"];
oper.DayTime = float.Parse(Request["DayTime"]);
oper.WeekTime = float.Parse(Request["WeekTime"]);
oper.MonthTime = float.Parse(Request["MonthTime"]);
int operid = new AchieveBLL.ProduceBLL().AddOper(oper);
//int operid = new AchieveDAL.ProduceDAL().AddOper(oper);
if (operid > 0)
{
return(Content("{\"msg\":\"添加成功！\",\"success\":true}"));
}
else
{
return(Content("{\"msg\":\"添加失败！\",\"success\":false}"));
}
}
catch (Exception ex)
{
return(Content("{\"msg\":\"添加失败," + ex.Message + "\",\"success\":false}"));
}
}
/// <summary>
/// 根据工艺名获取工艺
/// </summary>
public OperEntity GetOperByOperNote(string OperNote)
{
string sql = "select top 1 OperID,OperNote,DayTime,WeekTime,MonthTime,UpdateTime,UpdateBy,Remark from tbOper where OperNote = @OperNote";
OperEntity oper = null;
DataTable dt = SqlHelper.GetDataTable(SqlHelper.connStr, CommandType.Text, sql, new SqlParameter("@OperNote", OperNote));
if (dt.Rows.Count > 0)
{
oper = new OperEntity();
DataRowToModel(oper, dt.Rows[0]);
return(oper);
}
else
{
return(null);
}
}
/// <summary>
/// 把DataRow行转成实体类对象
/// </summary>
private void DataRowToModel(OperEntity model, DataRow dr)
{
if (!DBNull.Value.Equals(dr["OperID"]))
{
model.OperID = int.Parse(dr["OperID"].ToString());
}
if (!DBNull.Value.Equals(dr["OperNote"]))
{
model.OperNote = dr["OperNote"].ToString();
}
if (!DBNull.Value.Equals(dr["DayTime"]))
{
model.DayTime = float.Parse(dr["DayTime"].ToString());
}
if (!DBNull.Value.Equals(dr["WeekTime"]))
{
model.WeekTime = float.Parse(dr["WeekTime"].ToString());
}
if (!DBNull.Value.Equals(dr["MonthTime"]))
{
model.WeekTime = float.Parse(dr["MonthTime"].ToString());
}
if (!DBNull.Value.Equals(dr["Remark"]))
{
model.Remark = dr["Remark"].ToString();
}
if (!DBNull.Value.Equals(dr["UpdateTime"]))
{
model.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]);
}
if (!DBNull.Value.Equals(dr["UpdateBy"]))
{
model.UpdateBy = dr["UpdateBy"].ToString();
}
}
