public DataTable CheckStoreCode(AddEmployeeParam addEmployeeParam) { StringBuilder selectBuilder = new StringBuilder(); selectBuilder.AppendFormat(EmployeeSql.SELECT_T_BUSS_STORE_CODE_BY_STORE_CODE, addEmployeeParam.storeCode); string select = selectBuilder.ToString(); DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(select, "T").Tables[0]; return(dt); }
public AddEmployeeParam CheckOldStoreId(string shopId) { AddEmployeeParam msg = new AddEmployeeParam(); StringBuilder selectBuilder = new StringBuilder(); selectBuilder.AppendFormat(EmployeeSql.SELECT_T_BUSS_STORE_CODE_BY_STORE_ID, shopId); string select = selectBuilder.ToString(); DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(select, "T").Tables[0]; if (dt.Rows.Count > 0) { msg.storeCode = dt.Rows[0]["store_code"].ToString(); msg.state = dt.Rows[0]["state"].ToString(); } return(msg); }
public bool UpdateT_buss_store_code(AddEmployeeParam addEmployeeParam, string shopId) { StringBuilder selectBuilder = new StringBuilder(); selectBuilder.AppendFormat(EmployeeSql.UPDATE_T_BUSS_STORE_CODE, addEmployeeParam.storeCode, addEmployeeParam.state, shopId); string select = selectBuilder.ToString(); if (DatabaseOperationWeb.ExecuteDML(select)) { return(true); } else { return(false); } }