本文整理汇总了C#中DBContext.Dispose方法的典型用法代码示例。如果您正苦于以下问题：C# DBContext.Dispose方法的具体用法？C# DBContext.Dispose怎么用？C# DBContext.Dispose使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DBContext的用法示例。
在下文中一共展示了DBContext.Dispose方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: SaveUser
public string SaveUser(string json)
{
string permission = "membsership-saveuser";
string entityName = "User";
string entityJson = Request["entityJson"];
JsonMessage jr = new JsonMessage();
DBContext db = new DBContext(EntityFormat);
try
{
if (entityJson == null) throw new Exception("entityJson is null");
entityJson = Server.UrlDecode(entityJson);
jr.Result = db.DoSave(permission, entityName, entityJson).GetPrimaryValue();
}
catch (Exception ex)
{
Utility.LogException(jr, ex);
}
finally
{
db.Dispose();
}
return JsonConvert.SerializeObject(jr);
}示例2: SyncJingKongPosData
//.........这里部分代码省略.........
//while (true)
//{
// try
// {
// string timeJson = http.DoGet("http://www.easybots.cn/api/holiday.php?d=" + tempTime);
// if (string.IsNullOrEmpty(timeJson)) throw new Exception("节假日返回值为空");
// string[] tempArr = timeJson.Substring(1, timeJson.Length - 2).Split(':');
// if (tempArr.Length != 2) throw new Exception("节假日返回值有变动");
// isHoldDay = Convert.ToInt32(tempArr[1].Replace('\"', ' ').Trim()) > 0;
// break;
// }
// catch (System.Net.WebException ex)
// {
// tryCount--;
// if (tryCount < 0) { GetLocalHolday(tempTime, db); break; }
// LogError("使用网络节假日发生网络异常，重试"+ tryCount, ex);
// }
// catch (Exception ex)
// {
// LogStep("easybots节假日返回异常(" + ex.Message + ")，尝试读取本地设置");
// }
// break;
//}
}
LogStep("计算手续费");
calcMoney(customerInfo, localItem);
LogStep("保存交易记录");
localItem.status = 0;
db.DoSave("", localItem);
newItemList.Add(localItem);
}
LogStep("查询是否有结算交易");
string sql = "select time,id from TransactionLogs where terminal='" + terminal + "' and tradeName in ('批上送结束(平账)','批上送结束(不平账)') and resultCode='00' and status =0";
DataTable dt = db.QueryTable(sql);
if (dt.Rows.Count > 0)
{
LogStep("有" + dt.Rows.Count + "笔结算数据，开始结算");
foreach (DataRow dr in dt.Rows)
{
string time = dr["time"].ToString();
string sumLogId = dr["id"].ToString();
sql = "select max(time) prevTime from TransactionLogs where terminal='" + terminal + "' and Status=0 and tradeName in ('批上送结束(平账)','批上送结束(不平账)') and resultCode='00' and time < '" + time + "'";
object o = db.ExecScalar(sql);
string prevTime = o.ToString();
//sum log of (消费)
sql = "select count(0) batchCount,sum(tradeMoney) tradeMoney,sum(discountMoney) discountMoney,sum(tixianfeiMoney) tixianfeiMoney from transactionLogs ";
string publicWhere = " where terminal='" + terminal + "' and Status=0 and isValid = 1 and resultCode='00'";
if (string.IsNullOrEmpty(prevTime))
publicWhere += " and time < '" + time + "'";
else
publicWhere += " and time between '" + prevTime + "' and '" + time + "'";
sql += publicWhere;
DataTable dtSum = db.QueryTable(sql);
if (dtSum.Rows.Count == 0 || dtSum.Rows[0]["batchCount"].Equals(0) || dtSum.Rows[0]["tradeMoney"] == DBNull.Value) continue;
TransactionSum sumData = new TransactionSum();
sumData.shanghuName = customerInfo.shanghuName;
sumData.faren = customerInfo.faren;
sumData.tradeMoney = Convert.ToDouble(dtSum.Rows[0]["tradeMoney"]);
sumData.discountMoney = Convert.ToDouble(dtSum.Rows[0]["discountMoney"]);
sumData.tixianfeiMoney = Convert.ToDouble(dtSum.Rows[0]["tixianfeiMoney"]);
sumData.finallyMoney = Convert.ToDouble(sumData.tradeMoney) - Convert.ToDouble(sumData.discountMoney) - Convert.ToDouble(sumData.tixianfeiMoney);
sumData.status = 0;
sumData.batchCount = Convert.ToInt32(dtSum.Rows[0]["batchCount"]);
sumData.createDate = time;//(new Date()).Format("yyyy-MM-dd hh:mm:ss")；用结算记录的时间
sumData.terminal = terminal;
db.DoSave("", sumData);//保存结算数据
//更新交易记录的标记
sql = "update TransactionLogs set sumid=" + sumData.id + " , status =1 " + publicWhere;
db.ExecuteCommand(sql);
sql = "update TransactionLogs set sumid=" + sumData.id + " , status =1 where id = " + sumLogId;
db.ExecuteCommand(sql);
}
}
else
{
LogStep("不需要结算");
}
if (maxTime == DateTime.MinValue) maxTime = DateTime.Today;
//update lastQuery
sql = "update Customers set lastQuery ='" + maxTime.ToString("yyyy-MM-dd") + "' where terminal='" + terminal + "' ";
db.ExecuteCommand(sql);
LogStep("关闭连接");
db.Close();
resultData.Result = newItemList;
}
catch (Exception ex)
{
resultData.Message = stepName + "时发生异常：" + ex.Message + "\r\nDBStepMessage:" + db.GetStepMsg();
LogError(stepName, ex);
db.Dispose();
}
finally {
System.Web.HttpContext.Current.Application.UnLock();
}
return resultData;
}