如下是我调用存储过程的代码。使用的是不返回值。提示错误在容器“CrmContext”中找不到 FunctionImport“CRM_AddCustormerInfo”请高手指点一下·
public static void ExecuteFunction(string functionName, System.Data.EntityClient.EntityParameter[] parameters)
{
using (CrmContext context = new CrmContext(EntityConnectionInfo.GetConntionString("CrmModel")))
{
EntityCommand comm = new EntityCommand();
comm.CommandType = CommandType.StoredProcedure;
comm.Connection = (EntityConnection)context.Connection;
comm.Parameters.AddRange(parameters);
comm.CommandText = context.DefaultContainerName+"."+ functionName;
try
{
if (comm.Connection.State != System.Data.ConnectionState.Open)
comm.Connection.Open();
var obj = comm.ExecuteNonQuery();
} catch (System.Exception)
{
throw;
}
finally
{
comm.Connection.Close();
}
}
}
public void AddCustomer(CustomerInfo crmInfo, CustomerBankInfo bankInfo, CustomerProductInfo productInfo)
{
EntityParameter[] param = {
new EntityParameter("GroupID",DbType.Int32, 4),
new EntityParameter("TradeID",DbType.Int32, 4),
new EntityParameter("ZoneID", DbType.Int32,4),
new EntityParameter("CharacterID", DbType.Int32, 4),
new EntityParameter("PardGradeID", DbType.Int32, 4),
new EntityParameter("CreditGradeID", DbType.Int32, 4),
new EntityParameter("Status", DbType.Int16, 30),
new EntityParameter("CustomerCode", DbType.String, 50),
new EntityParameter("FullName", DbType.String, 100),
new EntityParameter("ForeignName", DbType.String, 50),
new EntityParameter("ShortName", DbType.String, 50),
new EntityParameter("RegisteredPlace", DbType.String, 50),
new EntityParameter("CreatedDate", DbType.Date),
new EntityParameter("Corporation", DbType.String, 50),
new EntityParameter("Phone", DbType.String, 20),
new EntityParameter("MobliePhone", DbType.String, 20),
new EntityParameter("Fax", DbType.String, 20),
new EntityParameter("Website", DbType.String, 200),
new EntityParameter("PostalCode", DbType.String, 10),
new EntityParameter("PostalAddress", DbType.String, 200),
new EntityParameter("SendMode", DbType.String, 50), new EntityParameter("RegisteredCapital", DbType.Decimal),
new EntityParameter("Currency", DbType.String, 20),
new EntityParameter("Listed", DbType.String, 10),
new EntityParameter("CapitalComposed", DbType.String, 100),
new EntityParameter("BankOfDeposit", DbType.String, 50),
new EntityParameter("BankAccount", DbType.String, 50),
new EntityParameter("TermOfPayment", DbType.Date, 500),
new EntityParameter("TermOfAcceptance", DbType.String, 500),
new EntityParameter("VATRate", DbType.Decimal),
new EntityParameter("TaxIDNumber", DbType.String, 50),
new EntityParameter("BusinessItems", DbType.String, 500),
new EntityParameter("MajorProduct", DbType.String, 500),
new EntityParameter("IndustrialScenario", DbType.String, 100),
new EntityParameter("MajorClient", DbType.String, 500),
new EntityParameter("Competitors", DbType.String, 500),
new EntityParameter("MarketShare", DbType.String, 100),
new EntityParameter("CooperationPartner", DbType.Date, 500)
};
param[0].Value = crmInfo.GroupID;
param[1].Value = crmInfo.TradeID;
param[2].Value = crmInfo.ZoneID;
param[3].Value = crmInfo.CharacterID;
param[4].Value = crmInfo.PardGradeID;
param[5].Value = crmInfo.CreditGradeID;
param[6].Value = crmInfo.Status;
param[7].Value = crmInfo.CustomerCode;
param[8].Value = crmInfo.ForeignName;
param[9].Value = crmInfo.FullName;
param[10].Value = crmInfo.ShortName;
param[11].Value = crmInfo.RegisteredPlace;
param[12].Value = crmInfo.CreatedDate;
param[13].Value = crmInfo.Corporation;
param[14].Value = crmInfo.Phone;
param[15].Value = crmInfo.MobliePhone;
param[16].Value = crmInfo.Fax;
param[17].Value = crmInfo.Website;
param[18].Value = crmInfo.PostalCode;
param[19].Value = crmInfo.PostalAddress;
param[20].Value = crmInfo.SendMode; param[21].Value = bankInfo.RegisteredCapital;
param[22].Value = bankInfo.Currency;
param[23].Value = bankInfo.Listed;
param[24].Value = bankInfo.CapitalComposed;
param[25].Value = bankInfo.BankOfDeposit;
param[26].Value = bankInfo.BankAccount;
param[27].Value = bankInfo.TermOfPayment;
param[28].Value = bankInfo.TermOfAcceptance;
param[29].Value = bankInfo.VATRate;
param[30].Value = bankInfo.TaxIDNumber; param[31].Value = productInfo.BusinessItems;
param[32].Value = productInfo.MajorProduct;
param[33].Value = productInfo.IndustrialScenario;
param[34].Value = productInfo.MajorClient;
param[35].Value = productInfo.Competitors;
param[36].Value = productInfo.MarketShare;
param[37].Value = productInfo.CooperationPartner; ExecuteFunction("CRM_AddCustormerInfo", param);
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货