Пример #1
0
        internal static SqlCommand Insert_Update_PO_Items(PO_Items objEntity)
        {
            string ip = System.Web.HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"];

            if (string.IsNullOrEmpty(ip))
            {
                ip = System.Web.HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];
            }

            var parameters = new[]
            {
                CreateParameter("@action", SqlDbType.VarChar, objEntity.action),
                CreateParameter("@POID", SqlDbType.Int, Convert.ToInt32(objEntity.POID)),
                CreateParameter("@Description", SqlDbType.VarChar, objEntity.Description),
                CreateParameter("@Unit", SqlDbType.VarChar, objEntity.Unit),
                CreateParameter("@Qty", SqlDbType.Int, Convert.ToInt32(objEntity.Qty)),
                CreateParameter("@Rate", SqlDbType.Decimal, objEntity.Rate),
                CreateParameter("@Comments", SqlDbType.VarChar, objEntity.Comments),
                CreateParameter("@ID", SqlDbType.Int, Convert.ToInt32(objEntity.ID)),
            };

            return(CreateCommand("ins_PO_Items", parameters));
        }
Пример #2
0
 public List <PO_Items> Insert_Update_PO_Items(PO_Items objEntity)
 {
     return(SqlHelpers.GetObjects <PO_Items>(Util.Env, CommandFactory.Insert_Update_PO_Items(objEntity), AdminObjectFactory.Insert_Update_PO_Items_Factory));
 }