/// <summary>
/// xmltosql
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Xmltosql_Click(object sender, EventArgs e)
{
try
{
//需要增加事务处理
CRSContext context = new CRSContext(@"Data Source=10.1.2.249\sql2005;Initial Catalog=ECRS;Persist Security Info=True;User ID=sa;Password=$#@!;");
XElement element = XElement.Load(@"C:\Users\jack\Desktop\1.xml");
//insert
//foreach (XElement xel in element.Elements("title"))
//{
// Title title = new Title();
// title.Code = (string)xel.Element("Code");
// title.Name = (string)xel.Element("Name");
// //context.Log = Console.Out;
// context.Title.InsertOnSubmit(title);
// context.SubmitChanges();
//}
//update
var update_title = context.Title.Single(c => c.Code == "qq");
update_title.Sort_ID = 4;
context.SubmitChanges();
//delete
var del_title = context.Title.Single(c => c.Code == "a");
context.Title.DeleteOnSubmit(del_title);
context.SubmitChanges();
}
catch (Exception exp)
{
textBox1.Text = exp.Message;
//throw new Exception("Insert Failed");
}
}
private void 射存储过程_Click(object sender, EventArgs e)
{
CRSContext context = new CRSContext(@"Data Source=10.1.2.249\sql2005;Initial Catalog=ECRS;Persist Security Info=True;User ID=sa;Password=$#@!;");
//IEnumerable<DiscountByRule> result= context.GetDiscountByRule("12",'g001','001','001',3,'0',DateTime.Now);
#region 射sp之单一结果集
ISingleResult <DiscountByRule> result = context.GetDiscountByRule("12", "SVCARD", "T011", "0099", 3, "0");
foreach (DiscountByRule discount in result)
{
textBox1.Text = "Disc_food=" + discount.Disc_food + "Disc_beve=" + discount.Disc_beve + "Disc_misc=" + discount.Disc_misc;
}
#endregion
#region 射sp之标量返回
int count = context.Customers_Count_By_Region("WA");
Console.WriteLine(count);
#endregion
#region 射sp之多个可能形状的单一结果集
//分别返回各自的结果集合，如下：
//返回全部Customer结果集
IMultipleResults result_multi = context.Whole_Or_Partial_Customers_Set(1);
IEnumerable <WholeCustomersSetResult> shape1 =
result_multi.GetResult <WholeCustomersSetResult>();
foreach (WholeCustomersSetResult compName in shape1)
{
Console.WriteLine(compName.CompanyName);
}
//返回部分Customer结果集
result_multi = context.Whole_Or_Partial_Customers_Set(2);
IEnumerable <PartialCustomersSetResult> shape2 =
result_multi.GetResult <PartialCustomersSetResult>();
foreach (PartialCustomersSetResult con in shape2)
{
Console.WriteLine(con.ContactName);
}
#endregion
#region 射sp之多个结果集
IMultipleResults multi_result = context.Get_Customer_And_Orders("SEVES");
//返回Customer结果集
IEnumerable <CustomerResultSet> customer =
multi_result.GetResult <CustomerResultSet>();
//返回Orders结果集
IEnumerable <OrdersResultSet> orders =
multi_result.GetResult <OrdersResultSet>();
//在这里，我们读取CustomerResultSet中的数据
foreach (CustomerResultSet cust in customer)
{
Console.WriteLine(cust.CustomerID);
}
#endregion
#region 射sp之带输出参数
//我们使用下面的语句调用此存储过程：注意：输出参数是按引用传递的，以支持参数为“in/out”的方案。在这种情况下，参数仅为“out”
decimal?totalSales = 0;
string customerID = "ALFKI";
context.CustOrderTotal(customerID, ref totalSales);
Console.WriteLine("Total Sales for Customer '{0}' = {1:C}",
customerID, totalSales);
#endregion
}
private void EntitySetDemo_Click(object sender, EventArgs e)
{
CRSContext context = new CRSContext(@"Data Source=10.1.2.249\sql2005;Initial Catalog=ECRS;Persist Security Info=True;User ID=sa;Password=$#@!;");
var EntitySetResult =
from ship in context.Membership
from info in context.Memberinfo
where ship.code == "g001"
select new { ship.name, info.chname };
//IQueryable<Membership> EntitySetResult =
// from ship in context.Membership
// where ship.MemberInfo.FirstOrDefault().gh_no == ""
// select new { ship.code, ship.name };
//foreach (IQueryable t in EntitySetResult)
//{
//}
}
