public void Update01(DataTable dt) { if (dt == null) { return; } foreach (DataRow row in dt.Rows) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("USER_ID", row["USER_ID"]); parameters.AddParameter("USER_NAME", row["USER_NAME"]); parameters.AddParameter("PASSWD", row["PASSWD"]); parameters.AddParameter("REMARK", row["REMARK"]); parameters.AddParameter("LOGIN_ID", SharedCache.UserId); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); helper.ExecuteNonQuery( @"UPDATE TB_USER_INFO SET USER_NAME = @USER_NAME , PASSWD = @PASSWD , REMARK = @REMARK , UPDATE_USER = @LOGIN_ID , UPDATE_TIME = GETDATE() WHERE USER_ID = @USER_ID" , CommandType.Text , parameters); } }
public DataTable Select01(string userNo, string userName) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("USER_ID", userNo); parameters.AddParameter("USER_NAME", userName); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); DataTable resultTable = helper.FillTable( @"SELECT USER_ID ,USER_NAME ,PASSWD ,REMARK ,INSERT_USER ,INSERT_TIME ,UPDATE_USER ,UPDATE_TIME ,ROW_ID FROM TB_USER_INFO WHERE (@USER_ID = '' OR USER_ID = @USER_ID) AND (@USER_NAME = '' OR USER_NAME = @USER_NAME)" , CommandType.Text , parameters ); return(resultTable); }
public void Update01(DataTable dt) { if (dt == null) { return; } foreach (DataRow row in dt.Rows) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("USER_ID", row["USER_ID"]); parameters.AddParameter("VIEW_ID", row["VIEW_ID"]); parameters.AddParameter("AUTH_KIND", row["AUTH_KIND"]); parameters.AddParameter("AUTH_YN", row["AUTH_YN"]); parameters.AddParameter("LOGIN_ID", SharedCache.UserId); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); helper.ExecuteNonQuery( @"UPDATE TB_VIEW_AUTH SET AUTH_KIND = @AUTH_KIND , AUTH_YN = @AUTH_YN , UPDATE_USER = @LOGIN_ID , UPDATE_TIME = GETDATE() WHERE USER_ID = @USER_ID AND VIEW_ID = @VIEW_ID AND AUTH_KIND = @AUTH_KIND" , CommandType.Text , parameters); } }
public DataTable Select01(string userNo, string userName, string userRank) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("USER_ID", userNo); parameters.AddParameter("USER_NAME", userName); parameters.AddParameter("RANK_CODE", userRank); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); DataTable resultTable = helper.FillTable( @"SELECT USER_ID ,USER_NAME ,USER_GROUP ,RANK_CODE ,DEPARTMENT ,CONVERT(CHAR(10),ENTER_TIME,120) AS ENTER_TIME ,INSERT_USER ,INSERT_TIME ,UPDATE_USER ,UPDATE_TIME ,ROW_ID FROM TB_USER_INFO WHERE (@USER_ID = '' OR USER_ID = @USER_ID) AND (@USER_NAME = '' OR USER_NAME = @USER_NAME) AND (@RANK_CODE = '' OR RANK_CODE = @RANK_CODE)" , CommandType.Text , parameters ); return(resultTable); }
public void Update01(DataTable dt) { if (dt == null) { return; } foreach (DataRow row in dt.Rows) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("MENU_ID", row["MENU_ID"]); parameters.AddParameter("MENU_DESC", row["MENU_DESC"]); parameters.AddParameter("PARENT_ID", row["PARENT_ID"]); parameters.AddParameter("VIEW_ID", row["VIEW_ID"]); parameters.AddParameter("ORDER_SEQ", row["ORDER_SEQ"]); parameters.AddParameter("USE_YN", row["USE_YN"]); parameters.AddParameter("ASSEMBLY_NAME", row["ASSEMBLY_NAME"]); parameters.AddParameter("LOGIN_ID", SharedCache.UserId); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); helper.ExecuteNonQuery( @"UPDATE TB_MENU_INFO SET MENU_DESC = @MENU_DESC , PARENT_ID = @PARENT_ID , VIEW_ID = @VIEW_ID , ORDER_SEQ = @ORDER_SEQ , USE_YN = @USE_YN , ASSEMBLY_NAME = @ASSEMBLY_NAME , UPDATE_USER = @LOGIN_ID , UPDATE_TIME = GETDATE() WHERE MENU_ID = @MENU_ID" , CommandType.Text , parameters); } }
public DataTable Select01(string MCODE = "") { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("MCODE", MCODE); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); DataTable resultTable = helper.FillTable ( cmdText: @"SELECT MCODE , NAME , USE_YN , REMARK , INSERT_USER , INSERT_TIME , UPDATE_USER , UPDATE_TIME FROM TB_CODE_M WHERE (ISNULL(@MCODE, '') = '' OR MCODE = @MCODE) ORDER BY MCODE", cmdType: CommandType.Text, parameters: parameters ); return(resultTable); }
public DataTable Select02(string code) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("CODE", code); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); var query = @"SELECT USER_ID ,USER_NAME ,USER_GROUP ,RANK_CODE ,DEPARTMENT ,CONVERT(CHAR(10),ENTER_TIME,120) AS ENTER_TIME ,INSERT_USER ,INSERT_TIME ,UPDATE_USER ,UPDATE_TIME ,ROW_ID FROM TB_USER_INFO WHERE USER_GROUP = @CODE ORDER BY USER_ID"; var resultTable = helper.FillTable(query, CommandType.Text, parameters); return(resultTable); }
public DataTable Select02(string MCODE) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("MCODE", MCODE); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); DataTable resultTable = helper.FillTable ( cmdText: @"SELECT MCODE , CODE , NAME , ORDER_SEQ , USE_YN , INSERT_USER , INSERT_TIME , UPDATE_USER , UPDATE_TIME FROM TB_CODE_D WHERE MCODE = @MCODE ORDER BY ORDER_SEQ", cmdType: CommandType.Text, parameters: parameters ); return(resultTable); }
public void Update01(DataTable dt) { if (dt == null) { return; } foreach (DataRow row in dt.Rows) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("USER_ID", row["USER_ID"]); parameters.AddParameter("USER_NAME", row["USER_NAME"]); parameters.AddParameter("USER_GROUP", row["USER_GROUP"]); parameters.AddParameter("DEPARTMENT", row["DEPARTMENT"]); parameters.AddParameter("RANK_CODE", row["RANK_CODE"]); parameters.AddParameter("ENTER_TIME", row["ENTER_TIME"]); parameters.AddParameter("LOGIN_ID", SharedCache.UserId); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); helper.ExecuteNonQuery( @"UPDATE TB_USER_INFO SET USER_NAME = @USER_NAME , USER_GROUP = @USER_GROUP , DEPARTMENT = @DEPARTMENT , RANK_CODE = @RANK_CODE , ENTER_TIME = @ENTER_TIME , UPDATE_USER = @LOGIN_ID , UPDATE_TIME = GETDATE() WHERE USER_ID = @USER_ID" , CommandType.Text , parameters); } }
public DataTable ComboBoxCodeSelect(string masterCode) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("MCODE", masterCode); var query = @"SELECT * FROM TB_CODE_D WHERE MCODE = @MCODE ORDER BY ORDER_SEQ"; IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); DataTable resultTable = helper.FillTable(query, CommandType.Text, parameters); return(resultTable); }
public void Update02(DataTable dt) { if (dt == null) { return; } foreach (DataRow row in dt.Rows) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("USER_ID", row["USER_ID"]); parameters.AddParameter("USER_GROUP", row["USER_GROUP"]); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); var query = @"UPDATE TB_USER_INFO SET USER_GROUP = @USER_GROUP WHERE USER_ID = @USER_ID"; helper.ExecuteNonQuery(query, CommandType.Text, parameters); } }
public void Update02(DataTable dt) { if (dt == null) { return; } foreach (DataRow row in dt.Rows) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("MCODE", row["MCODE"]); parameters.AddParameter("CODE", row["CODE"]); parameters.AddParameter("NAME", row["NAME"]); parameters.AddParameter("ORDER_SEQ", row["ORDER_SEQ"]); parameters.AddParameter("USE_YN", row["USE_YN"]); parameters.AddParameter("LOGIN_ID", SharedCache.UserId); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); helper.ExecuteNonQuery( @"UPDATE TB_CODE_D SET CODE = @CODE , NAME = @NAME , ORDER_SEQ = @ORDER_SEQ , USE_YN = @USE_YN , UPDATE_USER = @LOGIN_ID , UPDATE_TIME = GETDATE() WHERE MCODE = @MCODE AND CODE = @CODE" , CommandType.Text , parameters); } }
public void Insert01(DataTable dt) { if (dt == null) { return; } foreach (DataRow row in dt.Rows) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("USER_ID", row["USER_ID"]); parameters.AddParameter("USER_NAME", row["USER_NAME"]); parameters.AddParameter("RANK_CODE", row["RANK_CODE"]); parameters.AddParameter("DEPARTMENT", row["DEPARTMENT"]); parameters.AddParameter("ENTER_TIME", row["ENTER_TIME"]); parameters.AddParameter("LOGIN_ID", SharedCache.UserId); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); helper.ExecuteNonQuery( @"INSERT TB_USER_INFO (USER_ID, USER_NAME, RANK_CODE, ENTER_TIME, DEPARTMENT, INSERT_USER, INSERT_TIME) VALUES (@USER_ID, @USER_NAME, @RANK_CODE, @ENTER_TIME, @DEPARTMENT, @LOGIN_ID, GETDATE())" , CommandType.Text , parameters); } }
public DataTable AuthInfoSelect() { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("USER_ID", SharedCache.UserId); var query = @"SELECT * FROM TB_VIEW_AUTH WHERE USER_ID = @USER_ID"; IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); DataTable resultTable = helper.FillTable(query, CommandType.Text, parameters); return(resultTable); }
public string PasswordCheck(string id, string password) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("USER_ID", id); parameters.AddParameter("PASSWD", password); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); var resultTable = helper.FillTable( cmdText: @"SELECT USER_ID FROM TB_USER_INFO A WHERE A.USER_ID = @USER_ID AND A.PASSWD = @PASSWD" , cmdType: CommandType.Text , parameters: parameters); if (resultTable.Rows.Count == 0) { return(null); } return((resultTable.Rows[0] as DataRow)["USER_ID"].ToString()); }
public void Delete02(DataTable dt) { if (dt == null) { return; } foreach (DataRow row in dt.Rows) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("MCODE", row["MCODE", DataRowVersion.Original]); parameters.AddParameter("CODE", row["CODE", DataRowVersion.Original]); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); helper.ExecuteNonQuery( @"DELETE FROM TB_CODE_D WHERE MCODE = @MCODE AND CODE = @CODE" , CommandType.Text , parameters); } }
public void Insert01(DataTable dt) { if (dt == null) { return; } foreach (DataRow row in dt.Rows) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("MCODE", row["MCODE"]); parameters.AddParameter("NAME", row["NAME"]); parameters.AddParameter("REMARK", row["REMARK"]); parameters.AddParameter("USE_YN", row["USE_YN"]); parameters.AddParameter("LOGIN_ID", SharedCache.UserId); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); helper.ExecuteNonQuery( @"INSERT INTO TB_CODE_M ( MCODE ,NAME ,USE_YN ,REMARK ,INSERT_USER ,INSERT_TIME ) VALUES ( @MCODE ,@NAME ,@USE_YN ,@REMARK ,@LOGIN_ID ,GETDATE() )" , CommandType.Text , parameters); } }
public void Insert01(DataTable dt) { if (dt == null) { return; } foreach (DataRow row in dt.Rows) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("USER_ID", row["USER_ID"]); parameters.AddParameter("VIEW_ID", row["VIEW_ID"]); parameters.AddParameter("AUTH_KIND", row["AUTH_KIND"]); parameters.AddParameter("AUTH_YN", row["AUTH_YN"]); parameters.AddParameter("LOGIN_ID", SharedCache.UserId); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); helper.ExecuteNonQuery( @"INSERT INTO TB_VIEW_AUTH ( USER_ID ,VIEW_ID ,AUTH_KIND ,AUTH_YN ,INSERT_USER ,INSERT_TIME ) VALUES ( @USER_ID ,@VIEW_ID ,@AUTH_KIND ,@AUTH_YN ,@LOGIN_ID ,GETDATE() )" , CommandType.Text , parameters); } }
public void Insert01(DataTable dt) { if (dt == null) { return; } foreach (DataRow row in dt.Rows) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("MENU_ID", row["MENU_ID"]); parameters.AddParameter("MENU_DESC", row["MENU_DESC"]); parameters.AddParameter("PARENT_ID", row["PARENT_ID"]); parameters.AddParameter("VIEW_ID", row["VIEW_ID"]); parameters.AddParameter("ORDER_SEQ", row["ORDER_SEQ"]); parameters.AddParameter("USE_YN", row["USE_YN"]); parameters.AddParameter("ASSEMBLY_NAME", row["ASSEMBLY_NAME"]); parameters.AddParameter("LOGIN_ID", SharedCache.UserId); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); helper.ExecuteNonQuery( @"INSERT INTO TB_MENU_INFO ( MENU_ID ,MENU_DESC ,PARENT_ID ,VIEW_ID ,ORDER_SEQ ,USE_YN ,ASSEMBLY_NAME ,INSERT_USER ,INSERT_TIME ) VALUES ( @MENU_ID ,@MENU_DESC ,@PARENT_ID ,@VIEW_ID ,@ORDER_SEQ ,@USE_YN ,@ASSEMBLY_NAME ,@LOGIN_ID ,GETDATE() )" , CommandType.Text , parameters); } }
public void Delete01(DataTable dt) { if (dt == null) { return; } foreach (DataRow row in dt.Rows) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("USER_ID", row["USER_ID", DataRowVersion.Original]); parameters.AddParameter("VIEW_ID", row["VIEW_ID", DataRowVersion.Original]); parameters.AddParameter("AUTH_KIND", row["AUTH_KIND", DataRowVersion.Original]); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); helper.ExecuteNonQuery( @"DELETE FROM TB_VIEW_AUTH WHERE USER_ID = @USER_ID AND VIEW_ID = @VIEW_ID AND AUTH_KIND = @AUTH_KIND" , CommandType.Text , parameters); } }
public void Delete01(DataTable dt) { if (dt == null) { return; } foreach (DataRow row in dt.Rows) { ParameterPackageCollection parameters = new ParameterPackageCollection(); parameters.AddParameter("USER_ID", row["USER_ID"]); IDBHelper helper = DbHelperFactory.CreateDbHelper("MES_DB"); helper.ExecuteNonQuery( @"DELETE FROM TB_USER_INFO WHERE USER_ID = @USER_ID" , CommandType.Text , parameters); } }