62,025
社区成员
发帖
与我相关
我的任务
分享
public string Constr = System.Configuration.ConfigurationManager.AppSettings["sqlConn.ConnectionString"].ToString();
public void tranClas()
{
using (SqlConnection con = new SqlConnection(Constr))
{
con.Open();
SqlTransaction ts = con.BeginTransaction();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.Transaction = ts;
try
{
Ent_Class_Profile claPro = new Ent_Class_Profile();
Ent_Class_Detail detail = new Ent_Class_Detail();
string str = Request.QueryString["data"].ToString();
JieXiJson[] jsda = new JavaScriptSerializer().Deserialize<JieXiJson[]>(str);
claPro.Category_ID = jsda[0].dlCourse;
claPro.Category_2nd_ID = jsda[0].dlSort;
claPro.Attendee_min = jsda[0].Attendee_min;
claPro.Attendee_Max = jsda[0].Attendee_Max;
claPro.Forct_Date =Convert.ToDateTime(jsda[0].Forct_Date);
claPro.Class_Qty = jsda[0].Class_Qty;
claPro.Class_Points = jsda[0].Class_Points;
claPro.Status = jsda[0].rds;
claPro.Publish_Date =Convert.ToDateTime(jsda[0].Publish_Date);
//添加主表class
bool bclas = tb.TranPlanClass(claPro);
// 得到此时最大classid
int clasId = tb.MaxClassId();
for (int i = 1; i <(claPro.Class_Qty+1); i++)
{
detail.Class_ID = clasId;
detail.Class_Sequence = jsda[i].Class_Sequence;
detail.Class_Time_Begin =Convert.ToDateTime(jsda[i].Class_Time_Begin.ToString());
detail.Class_Time_End = Convert.ToDateTime(jsda[i].Class_Time_End.ToString());
detail.Course_Code = jsda[i].Course_Code;
detail.Teacher_ID = jsda[i].Teacher_ID;
//添加从表classDetail
bool bdetai = tb.TranPlanClassDetail(detail);
}
ts.Commit();
}
catch(Exception)
{
if (ts != null)
{
ts.Rollback();
}
throw;
}
finally
{
if (ts != null)
{
con.Close();
}
}