public static bool InsertWheelAdapterConfigLog(SqlConnection conn, WheelAdapterConfigLog wacl)
{
string sql = @"INSERT INTO Configuration..WheelAdapterConfigLog(TID,OperateType,CreateDateTime,LastUpdateDateTime,Operator)
VALUES(@tid,@operatetype,@createdatetime,@lastupdatedatetime,@operator)";
var sqlParam = new[]
{
new SqlParameter("@tid", wacl.TID),
new SqlParameter("@operatetype", wacl.OperateType),
new SqlParameter("@createdatetime", wacl.CreateDateTime),
new SqlParameter("@lastupdatedatetime", wacl.LastUpdateDateTime),
new SqlParameter("@operator", wacl.Operator),
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParam) > 0 ? true : false);
}
public bool InsertWheelAdapterConfigLog(WheelAdapterConfigLog wacl)
{
try
{
return(handler.InsertWheelAdapterConfigLog(wacl));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new DownloadAppException(1, "InsertWheelAdapterConfigLog", ex);
Logger.Log(Level.Error, exception, "InsertWheelAdapterConfigLog");
throw ex;
}
}
public JsonResult SaveWheelAdapterConfig(WheelAdapterConfigWithTid wac)
{
bool flag = false;
if (wac.PKId == 0)
{
wac.CreateDateTime = DateTime.Now;
wac.LastUpdateDateTime = DateTime.Now;
wac.Creator = ThreadIdentity.Operator.Name;
flag = WheelAdapterConfigManager.InsertWheelAdapterConfigWithTid(wac);
WheelAdapterConfigLog wacl = new WheelAdapterConfigLog()
{
TID = wac.TID,
OperateType = 0,
CreateDateTime = wac.CreateDateTime,
LastUpdateDateTime = wac.LastUpdateDateTime,
Operator = wac.Creator,
};
bool flag1 = WheelAdapterConfigManager.InsertWheelAdapterConfigLog(wacl);
}
else
{
wac.LastUpdateDateTime = DateTime.Now;
flag = WheelAdapterConfigManager.UpdateWheelAdapterConfigWithTid(wac);
WheelAdapterConfigLog wacl = new WheelAdapterConfigLog()
{
TID = wac.TID,
OperateType = 1,
CreateDateTime = DateTime.Now,
LastUpdateDateTime = DateTime.Now,
Operator = ThreadIdentity.Operator.Name,
};
bool flag1 = WheelAdapterConfigManager.InsertWheelAdapterConfigLog(wacl);
}
if (flag)
{
RefreshCache(new List <string>()
{
wac.TID
});
}
return(Json(flag));
}
public bool InsertWheelAdapterConfigLog(WheelAdapterConfigLog wacl)
{
Func <SqlConnection, bool> action = (connection) => DalWheelAdapterConfig.InsertWheelAdapterConfigLog(connection, wacl);
return(dbManager.Execute(action));
}
public static bool InsertWheelAdapterConfigWithTid(SqlConnection conn, WheelAdapterConfigWithTid wac, IEnumerable <string> tids)
{
bool result = true;
var props = typeof(WheelAdapterConfigWithTid).GetProperties();
var getresults = SelectWheelAdapterConfigWithTid(conn, tids);
if (getresults != null && getresults.Any())
{
foreach (var item in getresults)
{
foreach (var propertyInfo in props.Where(x => x.PropertyType != typeof(DateTime?) &&
!string.Equals(x.Name, "pkid", StringComparison.OrdinalIgnoreCase) &&
!string.Equals(x.Name, "tid", StringComparison.OrdinalIgnoreCase)
))
{
var value = propertyInfo.GetValue(wac);
if (value != null)
{
propertyInfo.SetValue(item, value);
}
}
WheelAdapterConfigLog wacl = new WheelAdapterConfigLog()
{
TID = item.TID,
OperateType = 1,
CreateDateTime = wac.CreateDateTime,
LastUpdateDateTime = wac.LastUpdateDateTime,
Operator = wac.Creator,
};
InsertWheelAdapterConfigLog(conn, wacl);
item.LastUpdateDateTime = DateTime.Now;
item.Creator = wac.Creator;
result &= UpdateWheelAdapterConfigWithTid(conn, item);
}
}
var notgetitems = tids.Except(getresults.Select(x => x.TID)).Select(x =>
{
var item = JsonConvert.DeserializeObject <WheelAdapterConfigWithTid>(JsonConvert.SerializeObject(wac));
item.TID = x;
return(item);
});
foreach (var item in notgetitems)
{
WheelAdapterConfigLog wacl = new WheelAdapterConfigLog()
{
TID = item.TID,
OperateType = 0,
CreateDateTime = wac.CreateDateTime,
LastUpdateDateTime = wac.LastUpdateDateTime,
Operator = wac.Creator,
};
InsertWheelAdapterConfigLog(conn, wacl);
result &= InsertWheelAdapterConfigWithTid(conn, item);
}
return(result);
//string sql = "";
//var sqlParam = new List<SqlParameter>();
//var props = typeof(WheelAdapterConfigWithTid).GetProperties();
//List<string> insertsqls = new List<string>();
//foreach (var propertyInfo in props.Where(x => x.PropertyType != typeof(DateTime) && !string.Equals(x.Name, "pkid", StringComparison.OrdinalIgnoreCase)))
//{
//}
//var records = new List<SqlDataRecord>(tids.Count());
//foreach (var target in tids)
//{
// var record = new SqlDataRecord(new SqlMetaData("Pid", SqlDbType.Char, 40));
// var chars = new SqlChars(target.ToString());
// record.SetSqlChars(0, chars);
// records.Add(record);
//}
//using (var cmd = new SqlCommand(sql))
//{
// cmd.CommandType = CommandType.Text;
// SqlParameter p = new SqlParameter("@TVP", SqlDbType.Structured);
// p.TypeName = "dbo.Pids";
// p.Value = records;
// sqlParam.Add(p);
// //return await dbhelper.ExecuteNonQueryAsync(cmd);
// return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParam.ToArray()) > 0;
//}
}
