Esempio n. 1
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public MES.Model.form4_Customer_DebtorShipTo GetModel(int ID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 ID,requestid,BusinessRelationCode,ShipToNum,DebtorShipToCode,DebtorShipToName,cm_addr,AddressTypeCode,AddressStreet1,AddressZip,AddressCity,cm_region,ctry_country,Debtor_Domain,IsEffective,UpdateDate,UpdateById,UpdateByName,LngCode,turns from form4_Customer_DebtorShipTo ");
            strSql.Append(" where ID=@ID");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ID", SqlDbType.Int, 4)
            };
            parameters[0].Value = ID;

            MES.Model.form4_Customer_DebtorShipTo model = new MES.Model.form4_Customer_DebtorShipTo();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Esempio n. 2
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MES.Model.form4_Customer_DebtorShipTo model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into form4_Customer_DebtorShipTo(");
            strSql.Append("requestid,BusinessRelationCode,ShipToNum,DebtorShipToCode,DebtorShipToName,cm_addr,AddressTypeCode,AddressStreet1,AddressZip,AddressCity,cm_region,ctry_country,Debtor_Domain,IsEffective,UpdateDate,UpdateById,UpdateByName,LngCode,turns)");
            strSql.Append(" values (");
            strSql.Append("@requestid,@BusinessRelationCode,@ShipToNum,@DebtorShipToCode,@DebtorShipToName,@cm_addr,@AddressTypeCode,@AddressStreet1,@AddressZip,@AddressCity,@cm_region,@ctry_country,@Debtor_Domain,@IsEffective,@UpdateDate,@UpdateById,@UpdateByName,@LngCode,@turns)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@requestid",            SqlDbType.Int,          4),
                new SqlParameter("@BusinessRelationCode", SqlDbType.VarChar,     10),
                new SqlParameter("@ShipToNum",            SqlDbType.Int,          4),
                new SqlParameter("@DebtorShipToCode",     SqlDbType.VarChar,     10),
                new SqlParameter("@DebtorShipToName",     SqlDbType.VarChar,    100),
                new SqlParameter("@cm_addr",              SqlDbType.VarChar,     50),
                new SqlParameter("@AddressTypeCode",      SqlDbType.VarChar,     50),
                new SqlParameter("@AddressStreet1",       SqlDbType.VarChar,   2000),
                new SqlParameter("@AddressZip",           SqlDbType.VarChar,     10),
                new SqlParameter("@AddressCity",          SqlDbType.VarChar,     50),
                new SqlParameter("@cm_region",            SqlDbType.VarChar,     20),
                new SqlParameter("@ctry_country",         SqlDbType.VarChar,     50),
                new SqlParameter("@Debtor_Domain",        SqlDbType.VarChar,     50),
                new SqlParameter("@IsEffective",          SqlDbType.VarChar,     10),
                new SqlParameter("@UpdateDate",           SqlDbType.DateTime),
                new SqlParameter("@UpdateById",           SqlDbType.VarChar,     20),
                new SqlParameter("@UpdateByName",         SqlDbType.VarChar,     20),
                new SqlParameter("@LngCode",              SqlDbType.NVarChar,    50),
                new SqlParameter("@turns",                SqlDbType.NVarChar, 50)
            };

            parameters[0].Value  = model.requestid;
            parameters[1].Value  = model.BusinessRelationCode;
            parameters[2].Value  = model.ShipToNum;
            parameters[3].Value  = model.DebtorShipToCode;
            parameters[4].Value  = model.DebtorShipToName;
            parameters[5].Value  = model.cm_addr;
            parameters[6].Value  = model.AddressTypeCode;
            parameters[7].Value  = model.AddressStreet1;
            parameters[8].Value  = model.AddressZip;
            parameters[9].Value  = model.AddressCity;
            parameters[10].Value = model.cm_region;
            parameters[11].Value = model.ctry_country;
            parameters[12].Value = model.Debtor_Domain;
            parameters[13].Value = model.IsEffective;
            parameters[14].Value = model.UpdateDate;
            parameters[15].Value = model.UpdateById;
            parameters[16].Value = model.UpdateByName;
            parameters[17].Value = model.LngCode;
            parameters[18].Value = model.turns;


            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Esempio n. 3
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public MES.Model.form4_Customer_DebtorShipTo DataRowToModel(DataRow row)
 {
     MES.Model.form4_Customer_DebtorShipTo model = new MES.Model.form4_Customer_DebtorShipTo();
     if (row != null)
     {
         if (row["ID"] != null && row["ID"].ToString() != "")
         {
             model.ID = int.Parse(row["ID"].ToString());
         }
         if (row["requestid"] != null && row["requestid"].ToString() != "")
         {
             model.requestid = int.Parse(row["requestid"].ToString());
         }
         if (row["BusinessRelationCode"] != null)
         {
             model.BusinessRelationCode = row["BusinessRelationCode"].ToString();
         }
         if (row["ShipToNum"] != null && row["ShipToNum"].ToString() != "")
         {
             model.ShipToNum = int.Parse(row["ShipToNum"].ToString());
         }
         if (row["DebtorShipToCode"] != null)
         {
             model.DebtorShipToCode = row["DebtorShipToCode"].ToString();
         }
         if (row["DebtorShipToName"] != null)
         {
             model.DebtorShipToName = row["DebtorShipToName"].ToString();
         }
         if (row["cm_addr"] != null)
         {
             model.cm_addr = row["cm_addr"].ToString();
         }
         if (row["AddressTypeCode"] != null)
         {
             model.AddressTypeCode = row["AddressTypeCode"].ToString();
         }
         if (row["AddressStreet1"] != null)
         {
             model.AddressStreet1 = row["AddressStreet1"].ToString();
         }
         if (row["AddressZip"] != null)
         {
             model.AddressZip = row["AddressZip"].ToString();
         }
         if (row["AddressCity"] != null)
         {
             model.AddressCity = row["AddressCity"].ToString();
         }
         if (row["cm_region"] != null)
         {
             model.cm_region = row["cm_region"].ToString();
         }
         if (row["ctry_country"] != null)
         {
             model.ctry_country = row["ctry_country"].ToString();
         }
         if (row["Debtor_Domain"] != null)
         {
             model.Debtor_Domain = row["Debtor_Domain"].ToString();
         }
         if (row["IsEffective"] != null)
         {
             model.IsEffective = row["IsEffective"].ToString();
         }
         if (row["UpdateDate"] != null && row["UpdateDate"].ToString() != "")
         {
             model.UpdateDate = DateTime.Parse(row["UpdateDate"].ToString());
         }
         if (row["UpdateById"] != null)
         {
             model.UpdateById = row["UpdateById"].ToString();
         }
         if (row["UpdateByName"] != null)
         {
             model.UpdateByName = row["UpdateByName"].ToString();
         }
         if (row["LngCode"] != null)
         {
             model.LngCode = row["LngCode"].ToString();
         }
         if (row["turns"] != null)
         {
             model.turns = row["turns"].ToString();
         }
     }
     return(model);
 }
Esempio n. 4
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(MES.Model.form4_Customer_DebtorShipTo model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update form4_Customer_DebtorShipTo set ");
            strSql.Append("BusinessRelationCode=@BusinessRelationCode,");
            strSql.Append("ShipToNum=@ShipToNum,");
            strSql.Append("DebtorShipToCode=@DebtorShipToCode,");
            strSql.Append("DebtorShipToName=@DebtorShipToName,");
            strSql.Append("cm_addr=@cm_addr,");
            strSql.Append("AddressTypeCode=@AddressTypeCode,");
            strSql.Append("AddressStreet1=@AddressStreet1,");
            strSql.Append("AddressZip=@AddressZip,");
            strSql.Append("AddressCity=@AddressCity,");
            strSql.Append("cm_region=@cm_region,");
            strSql.Append("ctry_country=@ctry_country,");
            strSql.Append("Debtor_Domain=@Debtor_Domain,");
            strSql.Append("IsEffective=@IsEffective,");
            strSql.Append("UpdateDate=@UpdateDate,");
            strSql.Append("UpdateById=@UpdateById,");
            strSql.Append("UpdateByName=@UpdateByName,");
            strSql.Append("LngCode=@LngCode");
            strSql.Append(" where ID=@ID");
            SqlParameter[] parameters =
            {
                new SqlParameter("@BusinessRelationCode", SqlDbType.VarChar,   10),
                new SqlParameter("@ShipToNum",            SqlDbType.Int,        4),
                new SqlParameter("@DebtorShipToCode",     SqlDbType.VarChar,   10),
                new SqlParameter("@DebtorShipToName",     SqlDbType.VarChar,   50),
                new SqlParameter("@cm_addr",              SqlDbType.VarChar,   50),
                new SqlParameter("@AddressTypeCode",      SqlDbType.VarChar,   50),
                new SqlParameter("@AddressStreet1",       SqlDbType.VarChar,   50),
                new SqlParameter("@AddressZip",           SqlDbType.VarChar,   10),
                new SqlParameter("@AddressCity",          SqlDbType.VarChar,   50),
                new SqlParameter("@cm_region",            SqlDbType.VarChar,   20),
                new SqlParameter("@ctry_country",         SqlDbType.VarChar,   50),
                new SqlParameter("@Debtor_Domain",        SqlDbType.VarChar,   50),
                new SqlParameter("@IsEffective",          SqlDbType.VarChar,   10),
                new SqlParameter("@UpdateDate",           SqlDbType.DateTime),
                new SqlParameter("@UpdateById",           SqlDbType.VarChar,   20),
                new SqlParameter("@UpdateByName",         SqlDbType.VarChar,   20),
                new SqlParameter("@LngCode",              SqlDbType.NVarChar,  50),
                new SqlParameter("@ID",                   SqlDbType.Int,        4),
                new SqlParameter("@requestid",            SqlDbType.Int, 4)
            };
            parameters[0].Value  = model.BusinessRelationCode;
            parameters[1].Value  = model.ShipToNum;
            parameters[2].Value  = model.DebtorShipToCode;
            parameters[3].Value  = model.DebtorShipToName;
            parameters[4].Value  = model.cm_addr;
            parameters[5].Value  = model.AddressTypeCode;
            parameters[6].Value  = model.AddressStreet1;
            parameters[7].Value  = model.AddressZip;
            parameters[8].Value  = model.AddressCity;
            parameters[9].Value  = model.cm_region;
            parameters[10].Value = model.ctry_country;
            parameters[11].Value = model.Debtor_Domain;
            parameters[12].Value = model.IsEffective;
            parameters[13].Value = model.UpdateDate;
            parameters[14].Value = model.UpdateById;
            parameters[15].Value = model.UpdateByName;
            parameters[16].Value = model.LngCode;
            parameters[17].Value = model.ID;
            parameters[18].Value = model.requestid;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }