Beispiel #1
0
        public bool Update(PEIS.Model.OnCustRelationCustPEInfo model)
        {
            StringBuilder stringBuilder = new StringBuilder();

            stringBuilder.Append("update OnCustRelationCustPEInfo set ");
            stringBuilder.Append("ID_ArcCustomer=@ID_ArcCustomer,");
            stringBuilder.Append("IDCardNo=@IDCardNo,");
            stringBuilder.Append("ExamCardNo=@ExamCardNo,");
            stringBuilder.Append("ID_Customer=@ID_Customer,");
            stringBuilder.Append("Is_CompletePhysical=@Is_CompletePhysical,");
            stringBuilder.Append("ExamState=@ExamState");
            stringBuilder.Append(" where ID_CustRelation=@ID_CustRelation");
            SqlParameter[] array = new SqlParameter[]
            {
                new SqlParameter("@ID_ArcCustomer", SqlDbType.Int, 4),
                new SqlParameter("@IDCardNo", SqlDbType.VarChar, 30),
                new SqlParameter("@ExamCardNo", SqlDbType.VarChar, 30),
                new SqlParameter("@ID_Customer", SqlDbType.BigInt, 8),
                new SqlParameter("@Is_CompletePhysical", SqlDbType.Bit, 1),
                new SqlParameter("@ExamState", SqlDbType.Int, 4),
                new SqlParameter("@ID_CustRelation", SqlDbType.Int, 4)
            };
            array[0].Value = model.ID_ArcCustomer;
            array[1].Value = model.IDCardNo;
            array[2].Value = model.ExamCardNo;
            array[3].Value = model.ID_Customer;
            array[4].Value = model.Is_CompletePhysical;
            array[5].Value = model.ExamState;
            array[6].Value = model.ID_CustRelation;
            int num = DbHelperSQL.ExecuteSql(stringBuilder.ToString(), array);

            return(num > 0);
        }
Beispiel #2
0
        public PEIS.Model.OnCustRelationCustPEInfo GetModel(int ID_CustRelation)
        {
            StringBuilder stringBuilder = new StringBuilder();

            stringBuilder.Append("select  top 1 ID_CustRelation,ID_ArcCustomer,IDCardNo,ExamCardNo,ID_Customer,Is_CompletePhysical,ExamState from OnCustRelationCustPEInfo ");
            stringBuilder.Append(" where ID_CustRelation=@ID_CustRelation");
            SqlParameter[] array = new SqlParameter[]
            {
                new SqlParameter("@ID_CustRelation", SqlDbType.Int, 4)
            };
            array[0].Value = ID_CustRelation;
            PEIS.Model.OnCustRelationCustPEInfo onCustRelationCustPEInfo = new PEIS.Model.OnCustRelationCustPEInfo();
            DataSet dataSet = DbHelperSQL.Query(stringBuilder.ToString(), array);

            PEIS.Model.OnCustRelationCustPEInfo result;
            if (dataSet.Tables[0].Rows.Count > 0)
            {
                if (dataSet.Tables[0].Rows[0]["ID_CustRelation"].ToString() != "")
                {
                    onCustRelationCustPEInfo.ID_CustRelation = int.Parse(dataSet.Tables[0].Rows[0]["ID_CustRelation"].ToString());
                }
                if (dataSet.Tables[0].Rows[0]["ID_ArcCustomer"].ToString() != "")
                {
                    onCustRelationCustPEInfo.ID_ArcCustomer = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_ArcCustomer"].ToString()));
                }
                onCustRelationCustPEInfo.IDCardNo   = dataSet.Tables[0].Rows[0]["IDCardNo"].ToString();
                onCustRelationCustPEInfo.ExamCardNo = dataSet.Tables[0].Rows[0]["ExamCardNo"].ToString();
                if (dataSet.Tables[0].Rows[0]["ID_Customer"].ToString() != "")
                {
                    onCustRelationCustPEInfo.ID_Customer = new long?(long.Parse(dataSet.Tables[0].Rows[0]["ID_Customer"].ToString()));
                }
                if (dataSet.Tables[0].Rows[0]["Is_CompletePhysical"].ToString() != "")
                {
                    if (dataSet.Tables[0].Rows[0]["Is_CompletePhysical"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_CompletePhysical"].ToString().ToLower() == "true")
                    {
                        onCustRelationCustPEInfo.Is_CompletePhysical = new bool?(true);
                    }
                    else
                    {
                        onCustRelationCustPEInfo.Is_CompletePhysical = new bool?(false);
                    }
                }
                if (dataSet.Tables[0].Rows[0]["ExamState"].ToString() != "")
                {
                    onCustRelationCustPEInfo.ExamState = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ExamState"].ToString()));
                }
                result = onCustRelationCustPEInfo;
            }
            else
            {
                result = null;
            }
            return(result);
        }
        public List <PEIS.Model.OnCustRelationCustPEInfo> DataTableToList(DataTable dt)
        {
            List <PEIS.Model.OnCustRelationCustPEInfo> list = new List <PEIS.Model.OnCustRelationCustPEInfo>();
            int count = dt.Rows.Count;

            if (count > 0)
            {
                for (int i = 0; i < count; i++)
                {
                    PEIS.Model.OnCustRelationCustPEInfo onCustRelationCustPEInfo = new PEIS.Model.OnCustRelationCustPEInfo();
                    if (dt.Rows[i]["ID_CustRelation"].ToString() != "")
                    {
                        onCustRelationCustPEInfo.ID_CustRelation = int.Parse(dt.Rows[i]["ID_CustRelation"].ToString());
                    }
                    if (dt.Rows[i]["ID_ArcCustomer"].ToString() != "")
                    {
                        onCustRelationCustPEInfo.ID_ArcCustomer = new int?(int.Parse(dt.Rows[i]["ID_ArcCustomer"].ToString()));
                    }
                    onCustRelationCustPEInfo.IDCardNo   = dt.Rows[i]["IDCardNo"].ToString();
                    onCustRelationCustPEInfo.ExamCardNo = dt.Rows[i]["ExamCardNo"].ToString();
                    if (dt.Rows[i]["ID_Customer"].ToString() != "")
                    {
                        onCustRelationCustPEInfo.ID_Customer = new long?(long.Parse(dt.Rows[i]["ID_Customer"].ToString()));
                    }
                    if (dt.Rows[i]["Is_CompletePhysical"].ToString() != "")
                    {
                        if (dt.Rows[i]["Is_CompletePhysical"].ToString() == "1" || dt.Rows[i]["Is_CompletePhysical"].ToString().ToLower() == "true")
                        {
                            onCustRelationCustPEInfo.Is_CompletePhysical = new bool?(true);
                        }
                        else
                        {
                            onCustRelationCustPEInfo.Is_CompletePhysical = new bool?(false);
                        }
                    }
                    if (dt.Rows[i]["ExamState"].ToString() != "")
                    {
                        onCustRelationCustPEInfo.ExamState = new int?(int.Parse(dt.Rows[i]["ExamState"].ToString()));
                    }
                    list.Add(onCustRelationCustPEInfo);
                }
            }
            return(list);
        }
Beispiel #4
0
        public int Add(PEIS.Model.OnCustRelationCustPEInfo model)
        {
            StringBuilder stringBuilder = new StringBuilder();

            stringBuilder.Append("insert into OnCustRelationCustPEInfo(");
            stringBuilder.Append("ID_ArcCustomer,IDCardNo,ExamCardNo,ID_Customer,Is_CompletePhysical,ExamState)");
            stringBuilder.Append(" values (");
            stringBuilder.Append("@ID_ArcCustomer,@IDCardNo,@ExamCardNo,@ID_Customer,@Is_CompletePhysical,@ExamState)");
            stringBuilder.Append(";select @@IDENTITY");
            SqlParameter[] array = new SqlParameter[]
            {
                new SqlParameter("@ID_ArcCustomer", SqlDbType.Int, 4),
                new SqlParameter("@IDCardNo", SqlDbType.VarChar, 30),
                new SqlParameter("@ExamCardNo", SqlDbType.VarChar, 30),
                new SqlParameter("@ID_Customer", SqlDbType.BigInt, 8),
                new SqlParameter("@Is_CompletePhysical", SqlDbType.Bit, 1),
                new SqlParameter("@ExamState", SqlDbType.Int, 4)
            };
            array[0].Value = model.ID_ArcCustomer;
            array[1].Value = model.IDCardNo;
            array[2].Value = model.ExamCardNo;
            array[3].Value = model.ID_Customer;
            array[4].Value = model.Is_CompletePhysical;
            array[5].Value = model.ExamState;
            object single = DbHelperSQL.GetSingle(stringBuilder.ToString(), array);
            int    result;

            if (single == null)
            {
                result = 0;
            }
            else
            {
                result = Convert.ToInt32(single);
            }
            return(result);
        }
 public bool Update(PEIS.Model.OnCustRelationCustPEInfo model)
 {
     return(this.dal.Update(model));
 }
 public int Add(PEIS.Model.OnCustRelationCustPEInfo model)
 {
     return(this.dal.Add(model));
 }