private void setParameter(iSqlParameter[] parms, CategorytypeofInfo info) { try { int i = -1; parms[++i].Value = CFunctions.SetDBString(info.Code); parms[++i].Value = CFunctions.SetDBString(info.Name); parms[++i].Value = CFunctions.SetDBString(info.Note); parms[++i].Value = info.Status; parms[++i].Value = info.Markas; parms[++i].Value = CFunctions.SetDBDatetime(info.Timeupdate); parms[++i].Value = CFunctions.SetDBString(info.Username); parms[++i].Value = CFunctions.install_keyword(info.Name); parms[++i].Value = info.Id; return; } catch (Exception ex) { throw ex; } }
private CategorytypeofInfo getDataReader(iSqlDataReader dar) { try { int i = -1; CategorytypeofInfo info = new CategorytypeofInfo(); info.Code = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Note = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); return info; } catch (Exception ex) { throw ex; } }
private bool Saveitem(iSqlTransaction trans, CategorytypeofInfo info) { try { if (trans == null || info == null) return false; string SQL = string.Empty; if (info.Id == 0) { SQL = SQL_INSERT; //info.Id = (int)HELPER.getNewID(trans, TABLENAME); iSqlParameter[] parms = this.getParameter(SQL); this.setParameter(parms, info); HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms); } else if (HELPER.isExist(trans, TABLENAME, info.Id)) { SQL = SQL_UPDATE; iSqlParameter[] parms = this.getParameter(SQL); this.setParameter(parms, info); HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms); } else { SQL = SQL_INSERT; //info.Id = (int)HELPER.getNewID(trans, TABLENAME); iSqlParameter[] parms = this.getParameter(SQL); this.setParameter(parms, info); HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms); } return true; } catch (Exception ex) { throw ex; } }
public bool Save(CategorytypeofInfo info) { try { using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM)) { using (iSqlTransaction trans = iConn.BeginTransaction()) { try { this.Saveitem(trans, info); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw ex; } } iConn.Close(); } return true; } catch (Exception ex) { throw ex; } }
private bool Load_Info(int iid) { try { CategorytypeofInfo info = null; if (iid != 0) { info = (new CCategorytypeof(CCommon.LANG)).Wcmm_Getinfo(iid); if (info != null) { lstError = new List<Errorobject>(); lstError = Form_GetError(lstError, Errortype.Notice, Definephrase.Save_notice, "[" + info.Id + "] " + info.Name, null); Master.Form_ShowError(lstError); } } if (info == null) info = new CategorytypeofInfo(); chkSaveoption_golist.Checked = info.Id != 0; chkSaveoption_golang.Checked = info.Id == 0; txtId.Text = info.Id == 0 ? "" : info.Id.ToString(); txtId.ReadOnly = info.Id != 0; txtName.Text = info.Name; txtCode.Text = info.Code; txtNote.Text = info.Note; radStatus.SelectedValue = info.Status.ToString(); radMarkas.SelectedValue = info.Markas.ToString(); return true; } catch { return false; } }
private CategorytypeofInfo Take() { try { int iid = 0; int.TryParse(txtId.Text, out iid); CategorytypeofInfo info = (new CCategorytypeof(CCommon.LANG)).Wcmm_Getinfo(iid); if (info == null) info = new CategorytypeofInfo(); info.Id = iid; info.Name = txtName.Text.Trim(); info.Code = txtCode.Text.Trim(); info.Note = txtNote.Text.Trim(); info.Status = int.Parse(radStatus.SelectedValue); info.Markas = int.Parse(radMarkas.SelectedValue); info.Username = CCommon.Get_CurrentUsername(); info.Timeupdate = DateTime.Now; return info; } catch { return null; } }
private bool Save_Lang(CategorytypeofInfo info) { try { if (!CFunctions.IsMultiLanguage() || !chkSaveoption_golang.Checked) return false; int lang_num = CConstants.LANG_NUM; for (int i = 0; i < lang_num; i++) { string lang_val = ConfigurationSettings.AppSettings["LANG_" + i]; if (lang_val == CCommon.LANG) continue; CategorytypeofInfo lang_info = info.copy(); lang_info.Id = 0; lang_info.Status = (int)CConstants.State.Status.Waitactive; (new CCategorytypeof(lang_val)).Save(lang_info); } return true; } catch { return false; } }
private bool Save(CategorytypeofInfo info) { try { if (info == null) return false; return (new CCategorytypeof(CCommon.LANG)).Save(info); } catch { return false; } }