private void DgrdList_ItemDataBound(object sender, DataGridItemEventArgs e) { switch (e.Item.ItemType) { case ListItemType.Item: case ListItemType.AlternatingItem: { com.jwsoft.pm.entpm.model.ContactCorp contactCorp = (com.jwsoft.pm.entpm.model.ContactCorp)e.Item.DataItem; e.Item.Cells[2].Text = com.jwsoft.pm.entpm.PageHelper.QueryBasicCode(this, BasicType.CorpKind, contactCorp.CorpKind); e.Item.Cells[3].Text = com.jwsoft.pm.entpm.PageHelper.QueryBasicCode(this, BasicType.FareSort, contactCorp.WorkType); if (this.WindowType == "1") { e.Item.Attributes["ondblclick"] = "dbclose();"; } e.Item.Attributes["onclick"] = string.Concat(new object[] { "doClick(this,'", this.DgrdList.ClientID, "');doClickRow('", contactCorp.CorpID, "','", contactCorp.CorpName, "','", contactCorp.AuditState.ToString(), "');" }); e.Item.Attributes["onmouseout"] = "doMouseOut(this);"; e.Item.Attributes["onmouseover"] = "doMouseOver(this);"; return; } default: return; } }
public com.jwsoft.pm.entpm.model.ContactCorp ContactCorpList(int CorpID) { com.jwsoft.pm.entpm.model.ContactCorp corp = new com.jwsoft.pm.entpm.model.ContactCorp(); using (DataTable table = publicDbOpClass.DataTableQuary("SELECT * FROM XPM_Basic_ContactCorp where IsValid = 1 and CorpID = " + CorpID)) { if (table.Rows.Count > 0) { corp = this.DataRowToContactCorpInfo(table.Rows[0]); } } return(corp); }
public int AddContactCorp(com.jwsoft.pm.entpm.model.ContactCorp Cont) { object obj2 = ("" + "insert into XPM_Basic_ContactCorp ( CorpTypeID,CorpName,CorpKind,WorkType,Speciality,Aptitude,") + "Capital,UnderlayAbility,Address,CorpBrief,Corporation,LinkMan,Telephone,HandPhone,Fax," + "ShopCard,TaxCard,AccountBank,BankAccounts,PostCode,WebSite,PeopleNumber,Client,IsVisible,IsDefault,IsFixed,IsValid,Owner,VersionTime,UserCode ) "; string str2 = string.Concat(new object[] { obj2, "values (", Cont.CorpTypeID, ",'", Cont.CorpName.ToString(), "','", Cont.CorpKind.ToString(), "','", Cont.WorkType.ToString(), "'," }); string str3 = str2 + "'" + Cont.Speciality.ToString() + "','" + Cont.Aptitude.ToString() + "','" + Cont.Capital.ToString() + "','" + Cont.UnderlayAbility.ToString() + "',"; string str4 = str3 + "'" + Cont.Address.ToString() + "','" + Cont.CorpBrief.ToString() + "','" + Cont.Corporation.ToString() + "','" + Cont.LinkMan.ToString() + "',"; string str5 = str4 + "'" + Cont.Telephone.ToString() + "','" + Cont.HandPhone.ToString() + "','" + Cont.Fax.ToString() + "','" + Cont.ShopCard.ToString() + "',"; string str6 = str5 + "'" + Cont.TaxCard.ToString() + "','" + Cont.AccountBank.ToString() + "','" + Cont.BankAccounts.ToString() + "',"; object obj3 = str6 + "'" + Cont.PostCode.ToString() + "','" + Cont.WebSite.ToString() + "','" + Cont.PeopleNumber.ToString() + "','" + Cont.Client.ToString() + "',"; return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj3, Cont.IsVisible ? 1 : 0, ",", Cont.IsDefault ? 1 : 0, ",", Cont.IsFixed ? 1 : 0, ",", Cont.IsValid ? 1 : 0, ",'000000',getdate(),'", Cont.UserCode, "')" }))); }
public int UpdateContactCorp(com.jwsoft.pm.entpm.model.ContactCorp Cont) { string str = ""; object obj2 = str; string str2 = string.Concat(new object[] { obj2, "update XPM_Basic_ContactCorp set CorpTypeID =", Cont.CorpTypeID, " ,CorpName='", Cont.CorpName.ToString(), "'," }); string str3 = str2 + "CorpKind='" + Cont.CorpKind.ToString() + "',WorkType='" + Cont.WorkType.ToString() + "',Speciality='" + Cont.Speciality.ToString() + "',"; string str4 = str3 + "Aptitude='" + Cont.Aptitude.ToString() + "',Capital='" + Cont.Capital.ToString() + "',UnderlayAbility='" + Cont.UnderlayAbility.ToString() + "',"; string str5 = str4 + "Address='" + Cont.Address.ToString() + "',CorpBrief='" + Cont.CorpBrief.ToString() + "',Corporation='" + Cont.Corporation.ToString() + "',"; string str6 = str5 + "LinkMan='" + Cont.LinkMan.ToString() + "',Telephone='" + Cont.Telephone.ToString() + "',TaxCard='" + Cont.TaxCard.ToString() + "',"; string str7 = str6 + "HandPhone='" + Cont.HandPhone.ToString() + "',Fax='" + Cont.Fax.ToString() + "',ShopCard='" + Cont.ShopCard.ToString() + "',"; string str8 = str7 + "AccountBank='" + Cont.AccountBank.ToString() + "',BankAccounts='" + Cont.BankAccounts.ToString() + "',"; object obj3 = str8 + "PostCode='" + Cont.PostCode.ToString() + "',WebSite='" + Cont.WebSite.ToString() + "',"; object obj4 = string.Concat(new object[] { obj3, "PeopleNumber='", Cont.PeopleNumber.ToString(), "',Client='", Cont.Client.ToString(), "',IsVisible=", Cont.IsVisible ? 1 : 0, "," }); return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj4, "IsDefault=", Cont.IsVisible ? 1 : 0, ",IsFixed=", Cont.IsVisible ? 1 : 0, ",IsValid=", Cont.IsVisible ? 1 : 0, ",VersionTime=getdate() where CorpID =", Cont.CorpID }))); }
public int ContactCorpcount(com.jwsoft.pm.entpm.model.ContactCorp Cont) { string str = ""; return(publicDbOpClass.DataTableQuary(str + "select * from XPM_Basic_ContactCorp where CorpName='" + Cont.CorpName.ToString() + "'").Rows.Count); }
public int Add(ContactCorp value) { return(base.List.Add(value)); }
public void Remove(ContactCorp value) { base.List.Remove(value); }
public void Insert(int index, ContactCorp value) { base.List.Insert(index, value); }
public int Index(ContactCorp value) { return(base.List.IndexOf(value)); }
public bool Contains(ContactCorp value) { return(base.List.Contains(value)); }