private void WritePara(ManagerParameter para)
{
for (int i = 0; i < para.Count; i++)
{
txtMsg.Text += "\n" + para[i].ParameterName + ":" + para[i].Value;
}
}
/// <summary>
/// 释放资源。据说如果没有非托管的资源，是不用写析构函数的。所以，是不是不需要这个函数？
/// </summary>
public void Dispose()
{
if (_managerWebModel != null)
{
_managerWebModel = null;
}
if (_managerTran != null)
{
_managerTran = null;
}
if (_managerParameter != null)
{
_managerParameter = null;
}
_errorMessage = null;
Command.Parameters.Clear();
/* 有的时候close会报错，所以就注释掉了。
* 内部 .net framework 数据提供程序错误 1。
* if (Command.Connection != null)
* if (Command.Connection.State != ConnectionState.Closed)
* Command.Connection.Close();
*/
Command.Dispose();
}
private void IntoData(ManagerParameter para, DataRow dr, DataAccessLibrary dalTarget, DataAccessLibrary dalTargetSelect, string sqlExists, string sqlUpdate, string sqlInsert, string title)
{
for (int i = 0; i < para.Count; i++)
{
var parameterName = para[i].ParameterName.Replace("@", "");
switch (parameterName)
{
case "AddTime":
case "UpdateTime":
para[i].Value = System.Convert.ToDateTime(dr[parameterName]).ToString("yyyy-MM-dd HH:mm:ss");
break;
default:
para[i].Value = dr[parameterName].ToString();
break;
}
}
#region 添加或者修改
if (dalTargetSelect.ExecuteExists(string.Format(sqlExists, dr[0])))
{
//有记录，修改
dalTarget.ExecuteNonQuery(sqlUpdate);
txtMsg.Text += "\n修改一条" + title + "记录:" + dr[0];
}
else
{
//没有记录，添加
dalTarget.ExecuteNonQuery(sqlInsert);
txtMsg.Text += "\n添加一条" + title + "记录:" + dr[0];
}
//判断是否出错
if (dalTarget.ErrorMessage.Length > 1)
{
//导入数据时出错
txtMsg.Text += "\n导入" + title + "信息的时候出错！" + dr[0];
txtMsg.Text += "\n" + dalTarget.ErrorMessage + "\n==========\n";
WritePara(para);
}
#endregion
}
private void IntoData(ManagerParameter para, DataRow dr, DataAccessLibrary dalTarget, DataAccessLibrary dalTargetSelect, string sqlExists, string sqlUpdate, string sqlInsert, string title)
{
for (int i = 0; i < para.Count; i++)
{
var parameterName = para[i].ParameterName.Replace("@", "");
switch (parameterName)
{
case "AddTime":
case "UpdateTime":
para[i].Value = System.Convert.ToDateTime(dr[parameterName]).ToString("yyyy-MM-dd HH:mm:ss");
break;
default:
para[i].Value = dr[parameterName].ToString();
break;
}
}
#region 添加或者修改
if (dalTargetSelect.ExecuteExists(string.Format(sqlExists, dr[0])))
{
//有记录，修改
dalTarget.ExecuteNonQuery(sqlUpdate);
txtMsg.Text += "\n修改一条" + title + "记录:" + dr[0];
}
else
{
//没有记录，添加
dalTarget.ExecuteNonQuery(sqlInsert);
txtMsg.Text += "\n添加一条" + title + "记录:" + dr[0];
}
//判断是否出错
if (dalTarget.ErrorMessage.Length > 1)
{
//导入数据时出错
txtMsg.Text += "\n导入" + title + "信息的时候出错！" + dr[0];
txtMsg.Text += "\n" + dalTarget.ErrorMessage + "\n==========\n";
WritePara(para);
}
#endregion
}
private void WritePara(ManagerParameter para)
{
for (int i = 0; i < para.Count; i++)
{
txtMsg.Text += "\n" + para[i].ParameterName + ":" + para[i].Value;
}
}
