Exemplos de CaseOwnerModifyReq em C# (CSharp)

Exemplo n.º 1

        public int DataDelete(CaseOwnerModifyReq req)
        {
            int count = 0;

            using (DbCommand cmd = Db.CreateConnection().CreateCommand())
            {
                string sql = @"
DELETE FROM CASE_OWNER
    WHERE SN=@SN;
";
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = sql;
                Db.AddInParameter(cmd, "SN", DbType.String, req.CASE_OWNER.SN);
                count = Db.ExecuteNonQuery(cmd);
            }
            return(count);
        }

Exemplo n.º 2

        public int DataCreate(CaseOwnerModifyReq req)
        {
            int count = 0;

            using (DbCommand cmd = Db.CreateConnection().CreateCommand())
            {
                string sql = @"
INSERT CASE_OWNER (NAME1,NAME2,NAME3,NAME4,NAME5,NAME6,TEL1,TEL2,TEL3,TEL4,TEL5,TEL6,YEARS_OLD,ADDRESS,TEACHER1,TEACHER2,TEACHER3,FAMILY,RESIDENCE,NOTE,PROBLEM,EXPERIENCE,SUGGEST,CDATE,CUSER,MDATE,MUSER)
    VALUES (@NAME1,@NAME2,@NAME3,@NAME4,@NAME5,@NAME6,@TEL1,@TEL2,@TEL3,@TEL4,@TEL5,@TEL6,@YEARS_OLD,@ADDRESS,@TEACHER1,@TEACHER2,@TEACHER3,@FAMILY,@RESIDENCE,@NOTE,@PROBLEM,@EXPERIENCE,@SUGGEST,GETDATE(),@CUSER,GETDATE(),@MUSER) SET @SN = SCOPE_IDENTITY();
";
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = sql;

                Db.AddInParameter(cmd, "NAME1", DbType.String, req.CASE_OWNER.NAME1);
                Db.AddInParameter(cmd, "NAME2", DbType.String, req.CASE_OWNER.NAME2);
                Db.AddInParameter(cmd, "NAME3", DbType.String, req.CASE_OWNER.NAME3);
                Db.AddInParameter(cmd, "NAME4", DbType.String, req.CASE_OWNER.NAME4);
                Db.AddInParameter(cmd, "NAME5", DbType.String, req.CASE_OWNER.NAME5);
                Db.AddInParameter(cmd, "NAME6", DbType.String, req.CASE_OWNER.NAME6);
                Db.AddInParameter(cmd, "TEL1", DbType.String, req.CASE_OWNER.TEL1);
                Db.AddInParameter(cmd, "TEL2", DbType.String, req.CASE_OWNER.TEL2);
                Db.AddInParameter(cmd, "TEL3", DbType.String, req.CASE_OWNER.TEL3);
                Db.AddInParameter(cmd, "TEL4", DbType.String, req.CASE_OWNER.TEL4);
                Db.AddInParameter(cmd, "TEL5", DbType.String, req.CASE_OWNER.TEL5);
                Db.AddInParameter(cmd, "TEL6", DbType.String, req.CASE_OWNER.TEL6);
                Db.AddInParameter(cmd, "YEARS_OLD", DbType.String, req.CASE_OWNER.YEARS_OLD);
                Db.AddInParameter(cmd, "ADDRESS", DbType.String, req.CASE_OWNER.ADDRESS);
                Db.AddInParameter(cmd, "TEACHER1", DbType.String, req.CASE_OWNER.TEACHER1);
                Db.AddInParameter(cmd, "TEACHER2", DbType.String, req.CASE_OWNER.TEACHER2);
                Db.AddInParameter(cmd, "TEACHER3", DbType.String, req.CASE_OWNER.TEACHER3);
                Db.AddInParameter(cmd, "FAMILY", DbType.String, req.CASE_OWNER.FAMILY);
                Db.AddInParameter(cmd, "RESIDENCE", DbType.String, req.CASE_OWNER.RESIDENCE);
                Db.AddInParameter(cmd, "NOTE", DbType.String, req.CASE_OWNER.NOTE);
                Db.AddInParameter(cmd, "PROBLEM", DbType.String, req.CASE_OWNER.PROBLEM);
                Db.AddInParameter(cmd, "EXPERIENCE", DbType.String, req.CASE_OWNER.EXPERIENCE);
                Db.AddInParameter(cmd, "SUGGEST", DbType.String, req.CASE_OWNER.SUGGEST);
                Db.AddInParameter(cmd, "CUSER", DbType.String, req.CASE_OWNER.CUSER);
                Db.AddInParameter(cmd, "MUSER", DbType.String, req.CASE_OWNER.MUSER);

                Db.AddOutParameter(cmd, "SN", DbType.Int32, 1);
                count             = Db.ExecuteNonQuery(cmd);
                req.CASE_OWNER.SN = Db.GetParameterValue(cmd, "SN") as Int32? ?? null;
            }
            return(count);
        }

Exemplo n.º 3

        public int DataUpdate(CaseOwnerModifyReq req)
        {
            int count = 0;

            using (DbCommand cmd = Db.CreateConnection().CreateCommand())
            {
                string sql = @"
UPDATE CASE_OWNER
	SET SN=@SN,NAME1=@NAME1,NAME2=@NAME2,NAME3=@NAME3,NAME4=@NAME4,NAME5=@NAME5,NAME6=@NAME6,TEL1=@TEL1,TEL2=@TEL2,TEL3=@TEL3,TEL4=@TEL4,TEL5=@TEL5,TEL6=@TEL6,YEARS_OLD=@YEARS_OLD,ADDRESS=@ADDRESS,FAMILY=@FAMILY,EXPERIENCE=@EXPERIENCE,SUGGEST=@SUGGEST
    WHERE SN=@SN;
";
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = sql;

                Db.AddInParameter(cmd, "SN", DbType.String, req.CASE_OWNER.SN);
                Db.AddInParameter(cmd, "NAME1", DbType.String, req.CASE_OWNER.NAME1);
                Db.AddInParameter(cmd, "NAME2", DbType.String, req.CASE_OWNER.NAME2);
                Db.AddInParameter(cmd, "NAME3", DbType.String, req.CASE_OWNER.NAME3);
                Db.AddInParameter(cmd, "NAME4", DbType.String, req.CASE_OWNER.NAME4);
                Db.AddInParameter(cmd, "NAME5", DbType.String, req.CASE_OWNER.NAME5);
                Db.AddInParameter(cmd, "NAME6", DbType.String, req.CASE_OWNER.NAME6);
                Db.AddInParameter(cmd, "TEL1", DbType.String, req.CASE_OWNER.TEL1);
                Db.AddInParameter(cmd, "TEL2", DbType.String, req.CASE_OWNER.TEL2);
                Db.AddInParameter(cmd, "TEL3", DbType.String, req.CASE_OWNER.TEL3);
                Db.AddInParameter(cmd, "TEL4", DbType.String, req.CASE_OWNER.TEL4);
                Db.AddInParameter(cmd, "TEL5", DbType.String, req.CASE_OWNER.TEL5);
                Db.AddInParameter(cmd, "TEL6", DbType.String, req.CASE_OWNER.TEL6);
                Db.AddInParameter(cmd, "YEARS_OLD", DbType.String, req.CASE_OWNER.YEARS_OLD);
                Db.AddInParameter(cmd, "ADDRESS", DbType.String, req.CASE_OWNER.ADDRESS);
                Db.AddInParameter(cmd, "FAMILY", DbType.String, req.CASE_OWNER.FAMILY);
                Db.AddInParameter(cmd, "EXPERIENCE", DbType.String, req.CASE_OWNER.EXPERIENCE);
                Db.AddInParameter(cmd, "SUGGEST", DbType.String, req.CASE_OWNER.SUGGEST);
                count = Db.ExecuteNonQuery(cmd);
            }
            return(count);
        }