Ejemplo n.º 1
0
        public static void SaveSysCompany(SysCompany item, DataProviderAction action)
        {
            if (item == null)
            {
                return;
            }

            SqlConnection conn = DBUtils.GetConnection();
            SqlCommand    cmd  = DBUtils.GetCommand();

            try
            {
                cmd.Transaction = conn.BeginTransaction();

                ArrayList paras = new ArrayList();

                paras.Add(DBUtils.MakeInParam("@Co_ID", SqlDbType.NVarChar, 4, item.CoID));
                paras.Add(DBUtils.MakeInParam("@Co_Name", SqlDbType.NVarChar, 40, item.CoName));
                paras.Add(DBUtils.MakeInParam("@Crt_Date", SqlDbType.DateTime, item.CrtDate));
                paras.Add(DBUtils.MakeInParam("@Co_Address", SqlDbType.NVarChar, 100, item.CoAddress));
                paras.Add(DBUtils.MakeInParam("@Co_Post", SqlDbType.NVarChar, 10, item.CoPost));
                paras.Add(DBUtils.MakeInParam("@Co_Tele", SqlDbType.NVarChar, 30, item.CoTele));
                paras.Add(DBUtils.MakeInParam("@Co_Fax", SqlDbType.NVarChar, 30, item.CoFax));
                paras.Add(DBUtils.MakeInParam("@Co_EMail", SqlDbType.NVarChar, 32, item.CoEMail));
                paras.Add(DBUtils.MakeInParam("@Co_Man", SqlDbType.NVarChar, 6, item.CoMan));
                paras.Add(DBUtils.MakeInParam("@Sort_Order", SqlDbType.SmallInt, item.SortOrder));
                paras.Add(DBUtils.MakeInParam("@Co_Status", SqlDbType.SmallInt, item.CoStatus));
                paras.Add(DBUtils.MakeInParam("@Remark", SqlDbType.NVarChar, 20, item.Remark));
                paras.Add(DBUtils.MakeInParam("@Action", SqlDbType.Int, action));

                DBUtils.ExecuteNonQuery(conn, cmd, CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_Save_SysCompany", paras);

                cmd.Transaction.Commit();
            }
            catch
            {
                cmd.Transaction.Rollback();
                throw;
            }
            finally
            {
                DBUtils.SetDispose(conn, cmd);
            }
        }
Ejemplo n.º 2
0
        public static SysCompany PopulateSysCompany(IDataReader reader)
        {
            SysCompany item = new SysCompany();

            item.CoID    = reader["Co_ID"] as string;
            item.CoName  = reader["Co_Name"] as string;
            item.CrtDate = Convert.ToDateTime(reader["Crt_Date"]);
            if (reader["Co_Address"] != DBNull.Value)
            {
                item.CoAddress = reader["Co_Address"] as string;
            }
            if (reader["Co_Post"] != DBNull.Value)
            {
                item.CoPost = reader["Co_Post"] as string;
            }
            if (reader["Co_Tele"] != DBNull.Value)
            {
                item.CoTele = reader["Co_Tele"] as string;
            }
            if (reader["Co_Fax"] != DBNull.Value)
            {
                item.CoFax = reader["Co_Fax"] as string;
            }
            if (reader["Co_EMail"] != DBNull.Value)
            {
                item.CoEMail = reader["Co_EMail"] as string;
            }
            if (reader["Co_Man"] != DBNull.Value)
            {
                item.CoMan = reader["Co_Man"] as string;
            }
            item.SortOrder    = (short)reader["Sort_Order"];
            item.CoStatus     = (short)reader["Co_Status"];
            item.CoStatusName = reader["Co_Status_Name"] as string;
            if (reader["Remark"] != DBNull.Value)
            {
                item.Remark = reader["Remark"] as string;
            }

            return(item);
        }
Ejemplo n.º 3
0
        public static SysCompany GetSysCompany(string coid)
        {
            SysCompany item = new SysCompany();

            try
            {
                ArrayList paras = new ArrayList();
                paras.Add(DBUtils.MakeInParam("@Co_ID", SqlDbType.NVarChar, 4, coid));
                paras.Add(DBUtils.MakeInParam("@Get_Action", SqlDbType.NVarChar, 10, DataGetAction.Row.ToString().ToLower()));

                SqlDataReader reader = DBUtils.ExecuteReader(CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_Get_SysCompany", paras);

                if (reader.Read())
                {
                    item = PopulateSysCompany(reader);
                }

                reader.Close();
            }
            catch { throw; }

            return(item);
        }