コード例 #1
0
        public ActionResult SaveDetailInfo(RubberBeltDetail objDetail)
        {
            var user = (User)Session["CurrentUser"];
            //objMaster.UserId = user.EMPID;
            // objMaster.UName = user.EMPID;
            var res = _repository.SaveDetailInfo(objDetail);

            return(Json(res, JsonRequestBehavior.AllowGet));
        }
コード例 #2
0
        public string SaveDetailInfo(RubberBeltDetail objDetail)
        {
            string rv = "";

            try
            {
                var result = Insert_Update_Detail_Info("sp_insert_finishing_rubber_belt_detail_info", "SAVE_FINISHING_RUBBER_BELT_DETAIL", objDetail);
                rv = Operation.Success.ToString();
                return(result.Rows[0]["RIID"].ToString());
            }
            catch (Exception ex)
            {
                rv = ex.Message;
            }
            return(rv);
        }
コード例 #3
0
 public string SaveDetailInfo(RubberBeltDetail objDetail)
 {
     return(_service.SaveDetailInfo(objDetail));
 }
コード例 #4
0
 public DataTable Insert_Update_Detail_Info(string procedure, string callname, RubberBeltDetail objDetail)
 {
     dbConn = new SqlConnection(ConnectionString);
     dbConn.Open();
     cmd             = new SqlCommand(procedure, dbConn);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.Add(new SqlParameter("@call_name", callname));
     cmd.Parameters.Add(new SqlParameter("@RIID", objDetail.RIID));
     cmd.Parameters.Add(new SqlParameter("@RID", objDetail.RID));
     cmd.Parameters.Add(new SqlParameter("@GDate", objDetail.GDate));
     cmd.Parameters.Add(new SqlParameter("@BeforeThickness", objDetail.BeforeThickness));
     cmd.Parameters.Add(new SqlParameter("@AfterThickness", objDetail.AfterThickness));
     cmd.Parameters.Add(new SqlParameter("@AfterHardness", objDetail.AfterHardness));
     cmd.Parameters.Add(new SqlParameter("@ProdQnty", objDetail.ProdQnty));
     cmd.Parameters.Add(new SqlParameter("@Remarks", objDetail.Remarks));
     da = new SqlDataAdapter(cmd);
     dt = new DataTable();
     da.Fill(dt);
     dbConn.Close();
     return(dt);
 }