C# (CSharp) SysFunctions.SP_Spare_Get_PartLocation Beispiele

Beispiel #1

        private string GetPartLocation(string StrLocationCode)
        {
            DataSet ds            = new DataSet();
            string  StrLocationNM = "";

            try
            {
                SqlParameter[] param =
                {
                    new SqlParameter("@PartsTransLocCode", SqlDbType.Char),
                    new SqlParameter("@DealerCode",        SqlDbType.Char)
                };
                param[0].Value = StrLocationCode;
                param[1].Value = Session["DealerCode"].ToString();

                ds = SysFunc.SP_Spare_Get_PartLocation(param);

                if (ds.Tables[0].Rows.Count != 0)
                {
                    StrLocationNM = ds.Tables[0].Rows[0]["PartsTransLocDesc"].ToString();
                }

                return(StrLocationNM);
            }
            catch (Exception ex)
            {
                SysFunc.UserMsg(LbErr, Color.Red, ex.Message);
                return("");
            }
        }