예제 #1
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Garfield.Model.CRM_receive GetModel(int id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 id,Customer_id,Customer_name,Receive_num,Pay_type_id,Pay_type,Receive_amount,Receive_date,C_depid,C_depname,C_empid,C_empname,create_id,create_name,create_date,companyid,order_id,remarks,isDelete,Delete_time from CRM_receive ");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@id", SqlDbType.Int, 4)
            };
            parameters[0].Value = id;

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

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["id"].ToString() != "")
                {
                    model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
                }
                if (ds.Tables[0].Rows[0]["Customer_id"].ToString() != "")
                {
                    model.Customer_id = int.Parse(ds.Tables[0].Rows[0]["Customer_id"].ToString());
                }
                model.Customer_name = ds.Tables[0].Rows[0]["Customer_name"].ToString();
                model.Receive_num   = ds.Tables[0].Rows[0]["Receive_num"].ToString();
                if (ds.Tables[0].Rows[0]["Pay_type_id"].ToString() != "")
                {
                    model.Pay_type_id = int.Parse(ds.Tables[0].Rows[0]["Pay_type_id"].ToString());
                }
                model.Pay_type = ds.Tables[0].Rows[0]["Pay_type"].ToString();
                if (ds.Tables[0].Rows[0]["Receive_amount"].ToString() != "")
                {
                    model.Receive_amount = decimal.Parse(ds.Tables[0].Rows[0]["Receive_amount"].ToString());
                }
                if (ds.Tables[0].Rows[0]["Receive_date"].ToString() != "")
                {
                    model.Receive_date = DateTime.Parse(ds.Tables[0].Rows[0]["Receive_date"].ToString());
                }
                if (ds.Tables[0].Rows[0]["C_depid"].ToString() != "")
                {
                    model.C_depid = int.Parse(ds.Tables[0].Rows[0]["C_depid"].ToString());
                }
                model.C_depname = ds.Tables[0].Rows[0]["C_depname"].ToString();
                if (ds.Tables[0].Rows[0]["C_empid"].ToString() != "")
                {
                    model.C_empid = int.Parse(ds.Tables[0].Rows[0]["C_empid"].ToString());
                }
                model.C_empname = ds.Tables[0].Rows[0]["C_empname"].ToString();
                if (ds.Tables[0].Rows[0]["create_id"].ToString() != "")
                {
                    model.create_id = int.Parse(ds.Tables[0].Rows[0]["create_id"].ToString());
                }
                model.create_name = ds.Tables[0].Rows[0]["create_name"].ToString();
                if (ds.Tables[0].Rows[0]["create_date"].ToString() != "")
                {
                    model.create_date = DateTime.Parse(ds.Tables[0].Rows[0]["create_date"].ToString());
                }
                if (ds.Tables[0].Rows[0]["companyid"].ToString() != "")
                {
                    model.companyid = int.Parse(ds.Tables[0].Rows[0]["companyid"].ToString());
                }
                if (ds.Tables[0].Rows[0]["order_id"].ToString() != "")
                {
                    model.order_id = int.Parse(ds.Tables[0].Rows[0]["order_id"].ToString());
                }
                model.remarks = ds.Tables[0].Rows[0]["remarks"].ToString();
                if (ds.Tables[0].Rows[0]["isDelete"].ToString() != "")
                {
                    model.isDelete = int.Parse(ds.Tables[0].Rows[0]["isDelete"].ToString());
                }
                if (ds.Tables[0].Rows[0]["Delete_time"].ToString() != "")
                {
                    model.Delete_time = DateTime.Parse(ds.Tables[0].Rows[0]["Delete_time"].ToString());
                }
                return(model);
            }
            else
            {
                return(null);
            }
        }
예제 #2
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Garfield.Model.CRM_receive model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into CRM_receive(");
            strSql.Append("Customer_id,Customer_name,Receive_num,Pay_type_id,Pay_type,Receive_amount,Receive_date,C_depid,C_depname,C_empid,C_empname,create_id,create_name,create_date,companyid,order_id,remarks,isDelete,Delete_time,receive_direction_id,receive_direction_name,Receive_real)");
            strSql.Append(" values (");
            strSql.Append("@Customer_id,@Customer_name,@Receive_num,@Pay_type_id,@Pay_type,@Receive_amount,@Receive_date,@C_depid,@C_depname,@C_empid,@C_empname,@create_id,@create_name,@create_date,@companyid,@order_id,@remarks,@isDelete,@Delete_time,@receive_direction_id,@receive_direction_name,@Receive_real)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@Customer_id",            SqlDbType.Int,         4),
                new SqlParameter("@Customer_name",          SqlDbType.VarChar,   250),
                new SqlParameter("@Receive_num",            SqlDbType.VarChar,   250),
                new SqlParameter("@Pay_type_id",            SqlDbType.Int,         4),
                new SqlParameter("@Pay_type",               SqlDbType.VarChar,   250),
                new SqlParameter("@Receive_amount",         SqlDbType.Float,       8),
                new SqlParameter("@Receive_date",           SqlDbType.DateTime),
                new SqlParameter("@C_depid",                SqlDbType.Int,         4),
                new SqlParameter("@C_depname",              SqlDbType.VarChar,   250),
                new SqlParameter("@C_empid",                SqlDbType.Int,         4),
                new SqlParameter("@C_empname",              SqlDbType.VarChar,   250),
                new SqlParameter("@create_id",              SqlDbType.Int,         4),
                new SqlParameter("@create_name",            SqlDbType.VarChar,   250),
                new SqlParameter("@create_date",            SqlDbType.DateTime),
                new SqlParameter("@companyid",              SqlDbType.Int,         4),
                new SqlParameter("@order_id",               SqlDbType.Int,         4),
                new SqlParameter("@remarks",                SqlDbType.VarChar,    -1),
                new SqlParameter("@isDelete",               SqlDbType.Int,         4),
                new SqlParameter("@Delete_time",            SqlDbType.DateTime),
                new SqlParameter("@receive_direction_id",   SqlDbType.Int,         4),
                new SqlParameter("@receive_direction_name", SqlDbType.VarChar,   250),
                new SqlParameter("@Receive_real",           SqlDbType.Float, 8)
            };
            parameters[0].Value  = model.Customer_id;
            parameters[1].Value  = model.Customer_name;
            parameters[2].Value  = model.Receive_num;
            parameters[3].Value  = model.Pay_type_id;
            parameters[4].Value  = model.Pay_type;
            parameters[5].Value  = model.Receive_amount;
            parameters[6].Value  = model.Receive_date;
            parameters[7].Value  = model.C_depid;
            parameters[8].Value  = model.C_depname;
            parameters[9].Value  = model.C_empid;
            parameters[10].Value = model.C_empname;
            parameters[11].Value = model.create_id;
            parameters[12].Value = model.create_name;
            parameters[13].Value = model.create_date;
            parameters[14].Value = model.companyid;
            parameters[15].Value = model.order_id;
            parameters[16].Value = model.remarks;
            parameters[17].Value = model.isDelete;
            parameters[18].Value = model.Delete_time;
            parameters[19].Value = model.receive_direction_id;
            parameters[20].Value = model.receive_direction_name;
            parameters[21].Value = model.receive_real;

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

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
예제 #3
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Garfield.Model.CRM_receive model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update CRM_receive set ");
            strSql.Append("Customer_id=@Customer_id,");
            strSql.Append("Customer_name=@Customer_name,");
            strSql.Append("Receive_num=@Receive_num,");
            strSql.Append("Pay_type_id=@Pay_type_id,");
            strSql.Append("Pay_type=@Pay_type,");
            strSql.Append("Receive_amount=@Receive_amount,");
            strSql.Append("Receive_date=@Receive_date,");
            strSql.Append("C_depid=@C_depid,");
            strSql.Append("C_depname=@C_depname,");
            strSql.Append("C_empid=@C_empid,");
            strSql.Append("C_empname=@C_empname,");
            strSql.Append("companyid=@companyid,");
            strSql.Append("order_id=@order_id,");
            strSql.Append("remarks=@remarks,");
            strSql.Append("receive_direction_id=@receive_direction_id,");
            strSql.Append("receive_direction_name=@receive_direction_name,");
            strSql.Append("Receive_real=@Receive_real");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@Customer_id",            SqlDbType.Int,         4),
                new SqlParameter("@Customer_name",          SqlDbType.VarChar,   250),
                new SqlParameter("@Receive_num",            SqlDbType.VarChar,   250),
                new SqlParameter("@Pay_type_id",            SqlDbType.Int,         4),
                new SqlParameter("@Pay_type",               SqlDbType.VarChar,   250),
                new SqlParameter("@Receive_amount",         SqlDbType.Float,       8),
                new SqlParameter("@Receive_date",           SqlDbType.DateTime),
                new SqlParameter("@C_depid",                SqlDbType.Int,         4),
                new SqlParameter("@C_depname",              SqlDbType.VarChar,   250),
                new SqlParameter("@C_empid",                SqlDbType.Int,         4),
                new SqlParameter("@C_empname",              SqlDbType.VarChar,   250),
                new SqlParameter("@companyid",              SqlDbType.Int,         4),
                new SqlParameter("@order_id",               SqlDbType.Int,         4),
                new SqlParameter("@remarks",                SqlDbType.VarChar,    -1),
                new SqlParameter("@receive_direction_id",   SqlDbType.Int,         4),
                new SqlParameter("@receive_direction_name", SqlDbType.VarChar,   250),
                new SqlParameter("@Receive_real",           SqlDbType.Float,       8),
                new SqlParameter("@id",                     SqlDbType.Int, 4)
            };
            parameters[0].Value  = model.Customer_id;
            parameters[1].Value  = model.Customer_name;
            parameters[2].Value  = model.Receive_num;
            parameters[3].Value  = model.Pay_type_id;
            parameters[4].Value  = model.Pay_type;
            parameters[5].Value  = model.Receive_amount;
            parameters[6].Value  = model.Receive_date;
            parameters[7].Value  = model.C_depid;
            parameters[8].Value  = model.C_depname;
            parameters[9].Value  = model.C_empid;
            parameters[10].Value = model.C_empname;
            parameters[11].Value = model.companyid;
            parameters[12].Value = model.order_id;
            parameters[13].Value = model.remarks;
            parameters[14].Value = model.receive_direction_id;
            parameters[15].Value = model.receive_direction_name;
            parameters[16].Value = model.receive_real;
            parameters[17].Value = model.id;


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

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