コード例 #1
0
        public string SaveMasterInfo(FinishingStockMaster objMaster)
        {
            string rv = "";

            try
            {
                var result = Insert_Update_MasterInfo("sp_insert_finishing_floor_stock_master_info", "SAVE_FINISHING_STOCK_MASTER", objMaster);
                rv = Operation.Success.ToString();
                return(result.Rows[0]["FID"].ToString());
            }
            catch (Exception ex)
            {
                rv = ex.Message;
            }
            return(rv);
        }
コード例 #2
0
 public DataTable Insert_Update_MasterInfo(string procedure, string callname, FinishingStockMaster objMaster)
 {
     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("@FID", objMaster.FID));
     cmd.Parameters.Add(new SqlParameter("@FDate", objMaster.FDate.ToString("dd-MMM-yyyy")));
     cmd.Parameters.Add(new SqlParameter("@Remarks", objMaster.Remarks));
     cmd.Parameters.Add(new SqlParameter("@Stock", objMaster.Stock));
     da = new SqlDataAdapter(cmd);
     dt = new DataTable();
     da.Fill(dt);
     dbConn.Close();
     return(dt);
 }
コード例 #3
0
 public string SaveMasterInfo(FinishingStockMaster objMaster)
 {
     return(_service.SaveMasterInfo(objMaster));
 }