예제 #1
0
    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;
        }
    }
예제 #2
0
 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);
 }
예제 #3
0
        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, "')" })));
        }
예제 #4
0
        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 })));
        }
예제 #5
0
        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);
        }
예제 #6
0
 public int Add(ContactCorp value)
 {
     return(base.List.Add(value));
 }
예제 #7
0
 public void Remove(ContactCorp value)
 {
     base.List.Remove(value);
 }
예제 #8
0
 public void Insert(int index, ContactCorp value)
 {
     base.List.Insert(index, value);
 }
예제 #9
0
 public int Index(ContactCorp value)
 {
     return(base.List.IndexOf(value));
 }
예제 #10
0
 public bool Contains(ContactCorp value)
 {
     return(base.List.Contains(value));
 }