/// <summary>
/// ����һ������
/// </summary>
public int Add(CoalTraffic.Model.TDYN_NoteHistory model)
{
//model.NoteCode=GetMaxId();
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TDYN_NoteHistory(");
strSql.Append("NameplateCode,PhoneNumber,SMSText,HistoryTime,SendTime,SendState)");
strSql.Append(" values (");
strSql.Append("@NameplateCode,@PhoneNumber,@SMSText,@HistoryTime,@SendTime,@SendState)");
SqlParameter[] parameters = {
new SqlParameter("@NameplateCode", SqlDbType.NVarChar),
new SqlParameter("@PhoneNumber", SqlDbType.NVarChar),
new SqlParameter("@SMSText", SqlDbType.NVarChar),
new SqlParameter("@HistoryTime", SqlDbType.DateTime),
new SqlParameter("@SendTime", SqlDbType.DateTime),
new SqlParameter("@SendState", SqlDbType.VarChar,1)};
parameters[0].Value = model.NameplateCode;
parameters[1].Value = model.PhoneNumber;
parameters[2].Value = model.SMSText;
parameters[3].Value = model.HistoryTime;
parameters[4].Value = model.SendTime;
parameters[5].Value = model.SendState;
int iResult = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
return iResult;
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(CoalTraffic.Model.TT_LoadWeightByDay model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TT_LoadWeightByDay(");
strSql.Append("RoomCode,CollCode,CoalKindCode,TaxGroup,WeightTime,NetWeight,TaxAmount)");
strSql.Append(" values (");
strSql.Append("@RoomCode,@CollCode,@CoalKindCode,@TaxGroup,@WeightTime,@NetWeight,@TaxAmount)");
SqlParameter[] parameters = {
new SqlParameter("@RoomCode", SqlDbType.VarChar,10),
new SqlParameter("@CollCode", SqlDbType.VarChar,10),
new SqlParameter("@CoalKindCode", SqlDbType.VarChar,10),
new SqlParameter("@TaxGroup", SqlDbType.Decimal,9),
new SqlParameter("@WeightTime", SqlDbType.DateTime),
new SqlParameter("@NetWeight", SqlDbType.Decimal,9),
new SqlParameter("@TaxAmount", SqlDbType.Decimal,9)};
parameters[0].Value = model.RoomCode;
parameters[1].Value = model.CollCode;
parameters[2].Value = model.CoalKindCode;
parameters[3].Value = model.TaxGroup;
parameters[4].Value = model.WeightTime;
parameters[5].Value = model.NetWeight;
parameters[6].Value = model.TaxAmount;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public string Add(CoalTraffic.Model.TDY_ElecCoalYearSet model)
{
//model.YearCode=GetMaxId();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TDY_ElecCoalYearSet(");
strSql.Append("YearCode,YearName,CoalCode,Weight,IsForbid,Operator,OperateTime)");
strSql.Append(" values (");
strSql.Append("@YearCode,@YearName,@CoalCode,@Weight,@IsForbid,@Operator,@OperateTime)");
SqlParameter[] parameters = {
new SqlParameter("@YearCode", SqlDbType.NVarChar),
new SqlParameter("@YearName", SqlDbType.NVarChar),
new SqlParameter("@CoalCode", SqlDbType.NVarChar),
new SqlParameter("@Weight", SqlDbType.Decimal,5),
new SqlParameter("@IsForbid", SqlDbType.VarChar,1),
new SqlParameter("@Operator", SqlDbType.NVarChar),
new SqlParameter("@OperateTime", SqlDbType.DateTime)};
parameters[0].Value = model.YearCode;
parameters[1].Value = model.YearName;
parameters[2].Value = model.CoalCode;
parameters[3].Value = model.Weight;
parameters[4].Value = model.IsForbid;
parameters[5].Value = model.Operator;
parameters[6].Value = model.OperateTime;
int i=DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
return i.ToString();
}
/// <summary>
/// ����һ������
/// </summary>
public bool Add(CoalTraffic.Model.TDY_Parcel model)
{
//model.ParcelCode=GetMaxId();
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TDY_Parcel(");
strSql.Append("ParcelCode,CountryCode,ParcelName,Remark,IsForbid)");
strSql.Append(" values (");
strSql.Append("@ParcelCode,@CountryCode,@ParcelName,@Remark,@IsForbid)");
SqlParameter[] parameters = {
new SqlParameter("@ParcelCode", SqlDbType.VarChar,10),
new SqlParameter("@CountryCode", SqlDbType.VarChar,10),
new SqlParameter("@ParcelName", SqlDbType.NVarChar),
new SqlParameter("@Remark", SqlDbType.NVarChar),
new SqlParameter("@IsForbid", SqlDbType.VarChar,1)};
parameters[0].Value = model.ParcelCode;
parameters[1].Value = model.CountryCode;
parameters[2].Value = model.ParcelName;
parameters[3].Value = model.Remark;
parameters[4].Value = model.IsForbid;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
return true;
else
return false;
}
/// <summary>
/// ����һ������
/// </summary>
public string Add(CoalTraffic.Model.T_UserInGroup model)
{
//model.UserCode=GetMaxId();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_UserInGroup(");
strSql.Append("UserCode,UGrpCode,SysCode)");
strSql.Append(" values (");
strSql.Append("@UserCode,@UGrpCode,@SysCode)");
SqlParameter[] parameters = {
new SqlParameter("@UserCode", SqlDbType.VarChar,20),
new SqlParameter("@UGrpCode", SqlDbType.VarChar,10),
new SqlParameter("@SysCode", SqlDbType.VarChar,50)};
parameters[0].Value = model.UserCode;
parameters[1].Value = model.UGrpCode;
parameters[2].Value = model.SysCode;
int iAffected = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (iAffected > 0)
{
return model.UserCode;
}
else
{
return string.Empty;
}
}
/// <summary>
/// ����һ������
/// </summary>
public string Add(CoalTraffic.Model.T_UserGroup model)
{
//model.UGrpCode=GetMaxId();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_UserGroup(");
strSql.Append("UGrpCode,UGrpName,UGrpType,IsForbid,Remark,SysCode)");
strSql.Append(" values (");
strSql.Append("@UGrpCode,@UGrpName,@UGrpType,@IsForbid,@Remark,@SysCode)");
SqlParameter[] parameters = {
new SqlParameter("@UGrpCode", SqlDbType.VarChar,10),
new SqlParameter("@UGrpName", SqlDbType.NVarChar),
new SqlParameter("@UGrpType", SqlDbType.VarChar,1),
new SqlParameter("@IsForbid", SqlDbType.VarChar,1),
new SqlParameter("@Remark", SqlDbType.NVarChar),
new SqlParameter("@SysCode", SqlDbType.VarChar,10)};
parameters[0].Value = model.UGrpCode;
parameters[1].Value = model.UGrpName;
parameters[2].Value = model.UGrpType;
parameters[3].Value = model.IsForbid;
parameters[4].Value = model.Remark;
parameters[5].Value = model.SysCode;
int iAffected = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (iAffected > 0)
{
return model.UGrpCode;
}
else
{
return string.Empty;
}
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(CoalTraffic.Model.TT_WaterBook model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TT_WaterBook(");
strSql.Append("TradeCode,CollCode,JournalCode,StartMoney,TradeMoney,EndMoney,Operator,TradeDate,TradeKind,Remark,WeightCode)");
strSql.Append(" values (");
strSql.Append("@TradeCode,@CollCode,@JournalCode,@StartMoney,@TradeMoney,@EndMoney,@Operator,@TradeDate,@TradeKind,@Remark,@WeightCode)");
SqlParameter[] parameters = {
new SqlParameter("@TradeCode", SqlDbType.VarChar,20),
new SqlParameter("@CollCode", SqlDbType.VarChar,10),
new SqlParameter("@JournalCode", SqlDbType.Int,4),
new SqlParameter("@StartMoney", SqlDbType.Decimal,9),
new SqlParameter("@TradeMoney", SqlDbType.Decimal,9),
new SqlParameter("@EndMoney", SqlDbType.Decimal,9),
new SqlParameter("@Operator", SqlDbType.NVarChar,20),
new SqlParameter("@TradeDate", SqlDbType.DateTime),
new SqlParameter("@TradeKind", SqlDbType.VarChar,10),
new SqlParameter("@Remark", SqlDbType.NVarChar,200),
new SqlParameter("@WeightCode", SqlDbType.VarChar,20)};
parameters[0].Value = model.TradeCode;
parameters[1].Value = model.CollCode;
parameters[2].Value = model.JournalCode;
parameters[3].Value = model.StartMoney;
parameters[4].Value = model.TradeMoney;
parameters[5].Value = model.EndMoney;
parameters[6].Value = model.Operator;
parameters[7].Value = model.TradeDate;
parameters[8].Value = model.TradeKind;
parameters[9].Value = model.Remark;
parameters[10].Value = model.WeightCode;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(CoalTraffic.Model.TT_NavicertLog model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TT_NavicertLog(");
strSql.Append("NavicertCode,BeforeState,AfterState,Event,Remark,Operator,OperateDate)");
strSql.Append(" values (");
strSql.Append("@NavicertCode,@BeforeState,@AfterState,@Event,@Remark,@Operator,@OperateDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@NavicertCode", SqlDbType.VarChar,20),
new SqlParameter("@BeforeState", SqlDbType.VarChar,1),
new SqlParameter("@AfterState", SqlDbType.VarChar,1),
new SqlParameter("@Event", SqlDbType.NVarChar,50),
new SqlParameter("@Remark", SqlDbType.NVarChar,200),
new SqlParameter("@Operator", SqlDbType.NVarChar,20),
new SqlParameter("@OperateDate", SqlDbType.DateTime)};
parameters[0].Value = model.NavicertCode;
parameters[1].Value = model.BeforeState;
parameters[2].Value = model.AfterState;
parameters[3].Value = model.Event;
parameters[4].Value = model.Remark;
parameters[5].Value = model.Operator;
parameters[6].Value = model.OperateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public string Add(CoalTraffic.Model.TT_CheckBang model)
{
#region �س���Ʊ
SqlParameter[] parameters = {
new SqlParameter("@CheckCode", SqlDbType.VarChar,20),
new SqlParameter("@WeightCode", SqlDbType.VarChar,20),
new SqlParameter("@NavicertCode", SqlDbType.VarChar,20),
new SqlParameter("@MarkedCardCode", SqlDbType.VarChar,20),
new SqlParameter("@NetWeight", SqlDbType.Decimal,9),
new SqlParameter("@RoomCode", SqlDbType.VarChar,10),
new SqlParameter("@IsPassed", SqlDbType.VarChar,1),
new SqlParameter("@CheckResult", SqlDbType.NVarChar,200),
new SqlParameter("@CheckTime", SqlDbType.DateTime),
new SqlParameter("@Operator", SqlDbType.NVarChar,20),
new SqlParameter("@FrontImage", SqlDbType.VarChar,32),
new SqlParameter("@FrontImageContent",SqlDbType.Image),
new SqlParameter("@BackImage", SqlDbType.VarChar,32),
new SqlParameter("@BackImageContent", SqlDbType.Image),
new SqlParameter("@UpImage", SqlDbType.VarChar,32),
new SqlParameter("@UpImageContent", SqlDbType.Image),
new SqlParameter("@RoomImage", SqlDbType.VarChar,32),
new SqlParameter("@RoomImageContent", SqlDbType.Image)
};
parameters[0].Value = model.CheckCode;
parameters[1].Value = model.WeightCode;
parameters[2].Value = model.NavicertCode;
parameters[3].Value = model.MarkedCardCode;
parameters[4].Value = model.NetWeight;
parameters[5].Value = model.RoomCode;
parameters[6].Value = model.IsPassed;
parameters[7].Value = model.CheckResult;
parameters[8].Value = model.CheckTime;
parameters[9].Value = model.Operator;
parameters[10].Value = model.FrontImage;
parameters[11].Value = model.FrontImageContent;
parameters[12].Value = model.BackImage;
parameters[13].Value = model.BackImageContent;
parameters[14].Value = model.UpImage;
parameters[15].Value = model.UpImageContent;
parameters[16].Value = model.RoomImage;
parameters[17].Value = model.RoomImageContent;
#endregion
try
{
DataSet ds = DbHelperSQL.RunProcedure("PT_CheckBang", parameters, "TT_CheckBang");
if (ds != null)
return ds.Tables[0].Rows[0][0].ToString();
else
return "";
}
catch
{
return "";
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public string Add(CoalTraffic.Model.TDY_MarkedCardActive model)
{
//model.ActivationCode=GetMaxId();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TDY_MarkedCardActive(");
strSql.Append("ActivationCode,MarkedCardCode,CardKind,CardCode,CardState,ActivationAmount,ActivationTime,Operation)");
strSql.Append(" values (");
strSql.Append("@ActivationCode,@MarkedCardCode,@CardKind,@CardCode,@CardState,@ActivationAmount,@ActivationTime,@Operation)");
SqlParameter[] parameters = {
new SqlParameter("@ActivationCode", SqlDbType.VarChar,10),
new SqlParameter("@MarkedCardCode", SqlDbType.VarChar,20),
new SqlParameter("@CardKind", SqlDbType.VarChar,1),
new SqlParameter("@CardCode", SqlDbType.NVarChar),
new SqlParameter("@CardState", SqlDbType.VarChar,1),
new SqlParameter("@ActivationAmount", SqlDbType.Int,4),
new SqlParameter("@ActivationTime", SqlDbType.DateTime),
new SqlParameter("@Operation", SqlDbType.NVarChar)};
parameters[0].Value = model.ActivationCode;
parameters[1].Value = model.MarkedCardCode;
parameters[2].Value = model.CardKind;
parameters[3].Value = model.CardCode;
parameters[4].Value = model.CardState;
parameters[5].Value = model.ActivationAmount;
parameters[6].Value = model.ActivationTime;
parameters[7].Value = model.Operation;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
return model.ActivationCode;
}
/// <summary>
/// ����һ������
/// </summary>
public string Add(CoalTraffic.Model.TDY_Position model)
{
try
{
//model.PositionCode=GetMaxId();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TDY_Position(");
strSql.Append("PositionCode,PositionName,DepartCode,Remark,Rights,IsForbid)");
strSql.Append(" values (");
strSql.Append("@PositionCode,@PositionName,@DepartCode,@Remark,@Rights,@IsForbid)");
SqlParameter[] parameters = {
new SqlParameter("@PositionCode", SqlDbType.NVarChar),
new SqlParameter("@PositionName", SqlDbType.NVarChar),
new SqlParameter("@DepartCode", SqlDbType.NVarChar),
new SqlParameter("@Remark", SqlDbType.NVarChar),
new SqlParameter("@Rights", SqlDbType.NVarChar),
new SqlParameter("@IsForbid", SqlDbType.VarChar,1)};
parameters[0].Value = model.PositionCode;
parameters[1].Value = model.PositionName;
parameters[2].Value = model.DepartCode;
parameters[3].Value = model.Remark;
parameters[4].Value = model.Rights;
parameters[5].Value = model.IsForbid;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
return model.PositionCode;
}
catch
{
return "";
}
}
/// <summary>
/// ����һ������
/// </summary>
public string Add(CoalTraffic.Model.TDY_IdentifierClip model)
{
//model.MarkedCardCode=GetMaxId();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TDY_IdentifierClip(");
strSql.Append("CoalKindCode,CollCode,DispathCardCode,MarkedCard,MarkedCardState,IsForbid,CardType)");
strSql.Append(" values (");
strSql.Append("@CoalKindCode,@CollCode,@DispathCardCode,@MarkedCard,@MarkedCardState,@IsForbid,@CardType)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@CoalKindCode", SqlDbType.VarChar,10),
new SqlParameter("@CollCode", SqlDbType.VarChar,10),
new SqlParameter("@DispathCardCode", SqlDbType.VarChar,10),
new SqlParameter("@MarkedCard", SqlDbType.NVarChar,20),
new SqlParameter("@MarkedCardState", SqlDbType.VarChar,1),
new SqlParameter("@IsForbid", SqlDbType.VarChar,1),
new SqlParameter("@CardType", SqlDbType.VarChar,1)};
parameters[0].Value = model.CoalKindCode;
parameters[1].Value = model.CollCode;
parameters[2].Value = model.DispathCardCode;
parameters[3].Value = model.MarkedCard;
parameters[4].Value = model.MarkedCardState;
parameters[5].Value = model.IsForbid;
parameters[6].Value = model.CardType;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
return model.MarkedCardCode.ToString();
}
/// <summary>
/// ����һ������
/// </summary>
public string Add(CoalTraffic.Model.TDY_SendCard model)
{
//model.DispathCardCode=GetMaxId();
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TDY_SendCard(");
strSql.Append("DispathCardCode,Amount,Buyer,Operator,BuyTime,DepartCode,IsForbid,CoalCode,CoalKindCode)");
strSql.Append(" values (");
strSql.Append("@DispathCardCode,@Amount,@Buyer,@Operator,@BuyTime,@DepartCode,@IsForbid,@CoalCode,@CoalKindCode)");
SqlParameter[] parameters = {
new SqlParameter("@DispathCardCode", SqlDbType.VarChar,20),
new SqlParameter("@Amount", SqlDbType.Decimal,9),
new SqlParameter("@Buyer", SqlDbType.NVarChar),
new SqlParameter("@Operator", SqlDbType.NVarChar),
new SqlParameter("@BuyTime", SqlDbType.DateTime),
new SqlParameter("@DepartCode", SqlDbType.VarChar,10),
new SqlParameter("@IsForbid", SqlDbType.VarChar,1),
new SqlParameter("@CoalCode", SqlDbType.VarChar,10),
new SqlParameter("@CoalKindCode", SqlDbType.VarChar,10)};
parameters[0].Value = model.DispathCardCode;
parameters[1].Value = model.Amount;
parameters[2].Value = model.Buyer;
parameters[3].Value = model.Operator;
parameters[4].Value = model.BuyTime;
parameters[5].Value = model.DepartCode;
parameters[6].Value = model.IsForbid;
parameters[7].Value = model.CoalCode;
parameters[8].Value = model.CoalKindCode;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
return model.DispathCardCode;
}
/// <summary>
/// ����һ������
/// </summary>
public string Add(CoalTraffic.Model.TDY_GFItems model)
{
//model.ItemCode=GetMaxId();
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TDY_GFItems(");
strSql.Append("ItemCode,ItemName,IsStat,IsForbid,Remark)");
strSql.Append(" values (");
strSql.Append("@ItemCode,@ItemName,@IsStat,@IsForbid,@Remark)");
SqlParameter[] parameters = {
new SqlParameter("@ItemCode", SqlDbType.VarChar,10),
new SqlParameter("@ItemName", SqlDbType.NVarChar),
new SqlParameter("@IsStat", SqlDbType.VarChar,1),
new SqlParameter("@IsForbid", SqlDbType.VarChar,1),
new SqlParameter("@Remark", SqlDbType.NVarChar)};
parameters[0].Value = model.ItemCode;
parameters[1].Value = model.ItemName;
parameters[2].Value = model.IsStat;
parameters[3].Value = model.IsForbid;
parameters[4].Value = model.Remark;
int iAffected = DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (iAffected > 0)
{
return model.ItemCode;
}
else
{
return string.Empty;
}
}
/// <summary>
/// ����һ������
/// </summary>
public string Add(CoalTraffic.Model.TDY_EmptyAgainBang model)
{
//model.AgainCode=GetMaxId();
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TDY_EmptyAgainBang(");
strSql.Append("AgainCode,EmptyCode,Proceduce,AgainReason,AgainType,FormerlyWeight,RoomCode,Operator,AgainTime)");
strSql.Append(" values (");
strSql.Append("@AgainCode,@EmptyCode,@Proceduce,@AgainReason,@AgainType,@FormerlyWeight,@RoomCode,@Operator,@AgainTime)");
SqlParameter[] parameters = {
new SqlParameter("@AgainCode", SqlDbType.VarChar,20),
new SqlParameter("@EmptyCode", SqlDbType.VarChar,20),
new SqlParameter("@Proceduce", SqlDbType.Decimal,9),
new SqlParameter("@AgainReason", SqlDbType.NVarChar),
new SqlParameter("@AgainType", SqlDbType.VarChar,1),
new SqlParameter("@FormerlyWeight", SqlDbType.Decimal,5),
new SqlParameter("@RoomCode", SqlDbType.VarChar,10),
new SqlParameter("@Operator", SqlDbType.NVarChar),
new SqlParameter("@AgainTime", SqlDbType.DateTime)};
parameters[0].Value = model.AgainCode;
parameters[1].Value = model.EmptyCode;
parameters[2].Value = model.Proceduce;
parameters[3].Value = model.AgainReason;
parameters[4].Value = model.AgainType;
parameters[5].Value = model.FormerlyWeight;
parameters[6].Value = model.RoomCode;
parameters[7].Value = model.Operator;
parameters[8].Value = model.AgainTime;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
return model.AgainCode;
}
/// <summary>
/// ����һ������
/// </summary>
public string Add(CoalTraffic.Model.TDY_CoalManageStation model)
{
//model.SiteCode=GetMaxId();
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TDY_CoalManageStation(");
strSql.Append("SiteCode,SiteName,IsForbid,VillageCode,Remark)");
strSql.Append(" values (");
strSql.Append("@SiteCode,@SiteName,@IsForbid,@VillageCode,@Remark)");
SqlParameter[] parameters = {
new SqlParameter("@SiteCode", SqlDbType.VarChar,10),
new SqlParameter("@SiteName", SqlDbType.NVarChar),
new SqlParameter("@IsForbid", SqlDbType.VarChar,1),
new SqlParameter("@VillageCode", SqlDbType.VarChar,10),
new SqlParameter("@Remark", SqlDbType.NVarChar)};
parameters[0].Value = model.SiteCode;
parameters[1].Value = model.SiteName;
parameters[2].Value = model.IsForbid;
parameters[3].Value = model.VillageCode;
parameters[4].Value = model.Remark;
string code=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters).ToString();
if (code != "")
{
return model.SiteCode;
}
else
{
return string.Empty;
}
}
/// <summary>
/// ����һ������
/// </summary>
public string Add(CoalTraffic.Model.TDY_CollKicket model)
{
//model.BuyCode=GetMaxId();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TDY_CollKicket(");
strSql.Append("BuyCode,CollCode,CoalTicketAmount,Buyer,Operator,SaleTime)");
strSql.Append(" values (");
strSql.Append("@BuyCode,@CollCode,@CoalTicketAmount,@Buyer,@Operator,@SaleTime)");
SqlParameter[] parameters = {
new SqlParameter("@BuyCode", SqlDbType.VarChar,20),
new SqlParameter("@CollCode", SqlDbType.VarChar,10),
new SqlParameter("@CoalTicketAmount", SqlDbType.Decimal,9),
new SqlParameter("@Buyer", SqlDbType.NVarChar,20),
new SqlParameter("@Operator", SqlDbType.NVarChar,20),
new SqlParameter("@SaleTime", SqlDbType.DateTime)};
parameters[0].Value = model.BuyCode;
parameters[1].Value = model.CollCode;
parameters[2].Value = model.CoalTicketAmount;
parameters[3].Value = model.Buyer;
parameters[4].Value = model.Operator;
parameters[5].Value = model.SaleTime;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
return model.BuyCode;
else
return string.Empty;
}
/// <summary>
/// ����һ������
/// </summary>
public string Add(CoalTraffic.Model.T_Navigation model)
{
//model.SysCode=GetMaxId();
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into T_Navigation(");
strSql.Append("SysCode,FunCode,IsShow,UserCode)");
strSql.Append(" values (");
strSql.Append("@SysCode,@FunCode,@IsShow,@UserCode)");
SqlParameter[] parameters = {
new SqlParameter("@SysCode", SqlDbType.VarChar,10),
new SqlParameter("@FunCode", SqlDbType.VarChar,10),
new SqlParameter("@IsShow", SqlDbType.VarChar,1),
new SqlParameter("@UserCode", SqlDbType.VarChar,10)};
parameters[0].Value = model.SysCode;
parameters[1].Value = model.FunCode;
parameters[2].Value = model.IsShow;
parameters[3].Value = model.UserCode;
int iAffected = DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (iAffected > 0)
{
return model.SysCode;
}
else
{
return string.Empty;
}
}
/// <summary>
/// ����һ������
/// </summary>
public bool Add(CoalTraffic.Model.T_Department model)
{
//model.DepartCode=GetMaxId();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Department(");
strSql.Append("DepartCode,DepartName,Telephone,Fathercode,SysCode,Remark,IsForbid)");
strSql.Append(" values (");
strSql.Append("@DepartCode,@DepartName,@Telephone,@Fathercode,@SysCode,@Remark,@IsForbid)");
SqlParameter[] parameters = {
new SqlParameter("@DepartCode", SqlDbType.VarChar,10),
new SqlParameter("@DepartName", SqlDbType.NVarChar),
new SqlParameter("@Telephone", SqlDbType.NVarChar),
new SqlParameter("@Fathercode", SqlDbType.VarChar,10),
new SqlParameter("@SysCode", SqlDbType.VarChar,10),
new SqlParameter("@Remark", SqlDbType.NVarChar),
new SqlParameter("@IsForbid", SqlDbType.VarChar,1)};
parameters[0].Value = model.DepartCode;
parameters[1].Value = model.DepartName;
parameters[2].Value = model.Telephone;
parameters[3].Value = model.Fathercode;
parameters[4].Value = model.SysCode;
parameters[5].Value = model.Remark;
parameters[6].Value = model.IsForbid;
int iAffected = DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (iAffected > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(CoalTraffic.Model.TT_TaxAssignDetail model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TT_TaxAssignDetail(");
strSql.Append("ItemDetailID,UnitCode,AssignAmount,OperateTime,Operator)");
strSql.Append(" values (");
strSql.Append("@ItemDetailID,@UnitCode,@AssignAmount,@OperateTime,@Operator)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ItemDetailID", SqlDbType.BigInt,8),
new SqlParameter("@UnitCode", SqlDbType.VarChar,10),
new SqlParameter("@AssignAmount", SqlDbType.Decimal,9),
new SqlParameter("@OperateTime", SqlDbType.DateTime),
new SqlParameter("@Operator", SqlDbType.NVarChar,20)};
parameters[0].Value = model.ItemDetailID;
parameters[1].Value = model.UnitCode;
parameters[2].Value = model.AssignAmount;
parameters[3].Value = model.OperateTime;
parameters[4].Value = model.Operator;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(string CardID, string CardNO, CoalTraffic.Model.TT_InitialCard model)
{
//对数据库中已有的记录，更新记录
string[] cardno = null;
string[] cardcode = null;
List<string> listSql = new List<string>();
List<SqlParameter[]> listParm = new List<SqlParameter[]>();
StringBuilder strSql = new StringBuilder("");
StringBuilder strAll = new StringBuilder("");
int i = 0;
if (CardID != "")
{
//对数据库中没有的卡号，添加记录
cardno = CardID.Split('|');
cardcode = CardNO.Split('|');
for (i = 0; i < cardno.Length; i++)
{
strAll.Append("insert into TT_InitialCard(");
strAll.Append("CardID,CardNO,CardType,InitialTime,IntialPerson)");
strAll.Append(" values (");
strAll.Append("'" + cardno[i] + "','" + cardcode[i] + "','" + model.CardType + "','" + model.InitialTime + "','" + model.IntialPerson + "');");
}
}
int iFlag = DbHelperSQL.ExecuteSql(strAll.ToString());
return iFlag > 0 ? true : false;
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(CoalTraffic.Model.TDY_ShadinessInfo model)
{
//model.ShadinessCode=GetMaxId();
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TDY_ShadinessInfo(");
strSql.Append("ShadinessType,Description,DataName,DataNumber,ShadinessUser,ShadinessDate,DisposalIdea,DisposalUser,DisposalDate,WeightBangCode)");
strSql.Append(" values (");
strSql.Append("@ShadinessType,@Description,@DataName,@DataNumber,@ShadinessUser,@ShadinessDate,@DisposalIdea,@DisposalUser,@DisposalDate,@WeightBangCode)");
SqlParameter[] parameters = {
new SqlParameter("@ShadinessType", SqlDbType.VarChar,20),
new SqlParameter("@Description", SqlDbType.VarChar,200),
new SqlParameter("@DataName", SqlDbType.VarChar,20),
new SqlParameter("@DataNumber", SqlDbType.VarChar,20),
new SqlParameter("@ShadinessUser", SqlDbType.VarChar,8),
new SqlParameter("@ShadinessDate", SqlDbType.DateTime),
new SqlParameter("@DisposalIdea", SqlDbType.VarChar,200),
new SqlParameter("@DisposalUser", SqlDbType.VarChar,8),
new SqlParameter("@DisposalDate", SqlDbType.DateTime),
new SqlParameter("@WeightBangCode", SqlDbType.VarChar,20)};
parameters[0].Value = model.ShadinessType;
parameters[1].Value = model.Description;
parameters[2].Value = model.DataName;
parameters[3].Value = model.DataNumber;
parameters[4].Value = model.ShadinessUser;
parameters[5].Value = model.ShadinessDate;
parameters[6].Value = model.DisposalIdea;
parameters[7].Value = model.DisposalUser;
parameters[8].Value = model.DisposalDate;
parameters[9].Value = model.WeightBangCode;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
return model.ShadinessCode;
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(CoalTraffic.Model.TDYN_PhoneDictionary model)
{
//model.PCode=GetMaxId();
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TDYN_PhoneDictionary(");
strSql.Append("TypeCode,PName,PhoneNumber,NameplateName,NameplateCode,IsForbid)");
strSql.Append(" values (");
strSql.Append("@TypeCode,@PName,@PhoneNumber,@NameplateName,@NameplateCode,@IsForbid)");
SqlParameter[] parameters = {
new SqlParameter("@TypeCode", SqlDbType.Int,4),
new SqlParameter("@PName", SqlDbType.VarChar,50),
new SqlParameter("@PhoneNumber", SqlDbType.VarChar,20),
new SqlParameter("@NameplateName", SqlDbType.VarChar,100),
new SqlParameter("@NameplateCode", SqlDbType.VarChar,20),
new SqlParameter("@IsForbid", SqlDbType.VarChar,1)};
parameters[0].Value = model.TypeCode;
parameters[1].Value = model.PName;
parameters[2].Value = model.PhoneNumber;
parameters[3].Value = model.NameplateName;
parameters[4].Value = model.NameplateCode;
parameters[5].Value = model.IsForbid;
int iResult=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
return iResult;
}
/// <summary>
/// ����һ������
/// </summary>
public string Add(CoalTraffic.Model.TDY_CoalAccountManage model)
{
//model.AmountCode=GetMaxId();
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TDY_CoalAccountManage(");
strSql.Append("AmountCode,CollCode,LastAmount,LowAmount,AccountState,AmountCodeID)");
strSql.Append(" values (");
strSql.Append("@AmountCode,@CollCode,@LastAmount,@LowAmount,@AccountState,@AmountCodeID)");
SqlParameter[] parameters = {
new SqlParameter("@AmountCode", SqlDbType.VarChar,10),
new SqlParameter("@CollCode", SqlDbType.VarChar,10),
new SqlParameter("@LastAmount", SqlDbType.Decimal,9),
new SqlParameter("@LowAmount", SqlDbType.Decimal,9),
new SqlParameter("@AccountState", SqlDbType.VarChar,1),
new SqlParameter("@AmountCodeID", SqlDbType.VarChar,20),
};
parameters[0].Value = model.AmountCode;
parameters[1].Value = model.CollCode;
parameters[2].Value = model.LastAmount;
parameters[3].Value = model.LowAmount;
parameters[4].Value = model.AccountState;
parameters[5].Value = model.AmountCodeID;
string icode=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters).ToString();
if (icode != "")
{
return model.AmountCode;
}
else
{
return string.Empty;
}
}
/// <summary>
/// ����һ������
/// </summary>
public bool Add(CoalTraffic.Model.TDY_CollKind model)
{
//model.CoalKindCode=GetMaxId();
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TDY_CollKind(");
strSql.Append("CoalKindCode,CoalKind,IsForbid,Remark)");
strSql.Append(" values (");
strSql.Append("@CoalKindCode,@CoalKind,@IsForbid,@Remark)");
SqlParameter[] parameters = {
new SqlParameter("@CoalKindCode", SqlDbType.VarChar,10),
new SqlParameter("@CoalKind", SqlDbType.NVarChar),
new SqlParameter("@IsForbid", SqlDbType.VarChar,1),
new SqlParameter("@Remark", SqlDbType.NVarChar)};
parameters[0].Value = model.CoalKindCode;
parameters[1].Value = model.CoalKind;
parameters[2].Value = model.IsForbid;
parameters[3].Value = model.Remark;
int iAffected = DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (iAffected > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// ����һ������
/// </summary>
public string Add(CoalTraffic.Model.TDY_GFDetail model)
{
//model.DetailCode=GetMaxId();
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TDY_GFDetail(");
strSql.Append("DetailCode,CoalKindCode,ItemCode,RoomCode,Amount,EffectTime,Operator,OperateTime)");
strSql.Append(" values (");
strSql.Append("@DetailCode,@CoalKindCode,@ItemCode,@RoomCode,@Amount,@EffectTime,@Operator,@OperateTime)");
SqlParameter[] parameters = {
new SqlParameter("@DetailCode", SqlDbType.VarChar,10),
new SqlParameter("@CoalKindCode", SqlDbType.VarChar,10),
new SqlParameter("@ItemCode", SqlDbType.VarChar,10),
new SqlParameter("@RoomCode", SqlDbType.VarChar,10),
new SqlParameter("@Amount", SqlDbType.Decimal,9),
new SqlParameter("@EffectTime", SqlDbType.DateTime),
new SqlParameter("@Operator", SqlDbType.NVarChar),
new SqlParameter("@OperateTime", SqlDbType.DateTime)};
parameters[0].Value = model.DetailCode;
parameters[1].Value = model.CoalKindCode;
parameters[2].Value = model.ItemCode;
parameters[3].Value = model.RoomCode;
parameters[4].Value = model.Amount;
parameters[5].Value = model.EffectTime;
parameters[6].Value = model.Operator;
parameters[7].Value = model.OperateTime;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
return model.DetailCode;
}
/// <summary>
/// ����һ������
/// </summary>
public string Add(CoalTraffic.Model.TDY_Colliery model)
{
//model.CollCode=GetMaxId();
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TDY_Colliery(");
strSql.Append("CollCode,SiteCode,CollName,AmountCode,MineOwner,OwnerPhone,CollCorporation,CorporationPhone,IdentifierManage,IMPhone,YearOutput,CollPhone,State,KeyWord,PassWord,Remark,imgYYZZ,imgZGZ,imgDJZ)");
strSql.Append(" values (");
strSql.Append("@CollCode,@SiteCode,@CollName,@AmountCode,@MineOwner,@OwnerPhone,@CollCorporation,@CorporationPhone,@IdentifierManage,@IMPhone,@YearOutput,@CollPhone,@State,@KeyWord,@PassWord,@Remark,@imgYYZZ,@imgZGZ,@imgDJZ)");
SqlParameter[] parameters = {
new SqlParameter("@CollCode", SqlDbType.VarChar,10),
new SqlParameter("@SiteCode", SqlDbType.VarChar,10),
new SqlParameter("@CollName", SqlDbType.NVarChar),
new SqlParameter("@AmountCode", SqlDbType.VarChar,10),
new SqlParameter("@MineOwner", SqlDbType.NVarChar),
new SqlParameter("@OwnerPhone", SqlDbType.NVarChar),
new SqlParameter("@CollCorporation", SqlDbType.NVarChar),
new SqlParameter("@CorporationPhone", SqlDbType.NVarChar),
new SqlParameter("@IdentifierManage", SqlDbType.NVarChar),
new SqlParameter("@IMPhone", SqlDbType.NVarChar),
new SqlParameter("@YearOutput", SqlDbType.Decimal,9),
new SqlParameter("@CollPhone", SqlDbType.NVarChar),
new SqlParameter("@State", SqlDbType.NVarChar),
new SqlParameter("@KeyWord", SqlDbType.NVarChar),
new SqlParameter("@PassWord", SqlDbType.NVarChar),
new SqlParameter("@Remark", SqlDbType.NVarChar),
new SqlParameter("@imgYYZZ", SqlDbType.NVarChar),
new SqlParameter("@imgZGZ", SqlDbType.NVarChar),
new SqlParameter("@imgDJZ",SqlDbType.NVarChar)
};
parameters[0].Value = model.CollCode;
parameters[1].Value = model.SiteCode;
parameters[2].Value = model.CollName;
parameters[3].Value = model.AmountCode;
parameters[4].Value = model.MineOwner;
parameters[5].Value = model.OwnerPhone;
parameters[6].Value = model.CollCorporation;
parameters[7].Value = model.CorporationPhone;
parameters[8].Value = model.IdentifierManage;
parameters[9].Value = model.IMPhone;
parameters[10].Value = model.YearOutput;
parameters[11].Value = model.CollPhone;
parameters[12].Value = model.State;
parameters[13].Value = model.KeyWord;
parameters[14].Value = model.PassWord;
parameters[15].Value=model.Remark;
parameters[16].Value = model.imgYYZZ;
parameters[17].Value = model.imgZGZ;
parameters[18].Value = model.imgDJZ;
string icode = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters).ToString();
if (icode != "")
{
return model.CollCode;
}
else
{
return string.Empty;
}
}
/// <summary>
/// ����һ������
/// </summary>
public string Add(CoalTraffic.Model.TT_CarInfo model)
{
try
{
SqlParameter[] parameters =
{
new SqlParameter("@RoomCode", SqlDbType.VarChar,4),
new SqlParameter("@EmptyWeight", SqlDbType.Decimal),
new SqlParameter("@MostWeight", SqlDbType.Decimal),
new SqlParameter("@CarNo", SqlDbType.NVarChar,20),
new SqlParameter("@CarType", SqlDbType.NVarChar,20),
new SqlParameter("@CarOwnerName", SqlDbType.NVarChar,20),
new SqlParameter("@CarOwnerIDCard", SqlDbType.NVarChar,20),
new SqlParameter("@CarOwnerPhone", SqlDbType.NVarChar,20),
new SqlParameter("@RandomCode", SqlDbType.VarChar,4),
new SqlParameter("@Operator", SqlDbType.NVarChar,20),
new SqlParameter("@BangType", SqlDbType.NVarChar,10),
new SqlParameter("@FirstImage", SqlDbType.VarChar),
new SqlParameter("@FileContent", SqlDbType.Image),
new SqlParameter("@CarCode", SqlDbType.VarChar,20),
new SqlParameter("@EmptyBangTime", SqlDbType.DateTime),
new SqlParameter("@DriveLicense",SqlDbType.VarChar,40),
new SqlParameter("@DriverName", SqlDbType.NVarChar,20),
new SqlParameter("@DriverIDCard", SqlDbType.NVarChar,20),
new SqlParameter("@DriverPhone", SqlDbType.NVarChar,20)
};
parameters[0].Value = model.RoomCode;
parameters[1].Value = model.EmptyWeight;
parameters[2].Value = model.MostWeight;
parameters[3].Value = model.CarNo;
parameters[4].Value = model.CarType;
parameters[5].Value = model.CarOwnerName;
parameters[6].Value = model.CarOwnerIDCard;
parameters[7].Value = model.CarOwnerPhone;
parameters[8].Value = model.RandomCode;
parameters[9].Value = model.Operator;
parameters[10].Value = model.BangType;
parameters[11].Value = model.FirstImage;
parameters[12].Value = model.FirstImageContent;
parameters[13].Value = model.CarCode;
parameters[14].Value = model.EmptyBangTime;
parameters[15].Value = model.DriveLicense;
parameters[16].Value = model.DriverName;
parameters[17].Value = model.DriverIDCard;
parameters[18].Value = model.DriverPhone;
DataSet ds = DbHelperSQL.RunProcedure("PT_CarInfo", parameters, "CarInfo");
if (ds != null)
return ds.Tables[0].Rows[0][0].ToString();
else
return "";
}
catch
{
return "";
}
}
/// <summary>
/// ����һ������
/// </summary>
public string Add(CoalTraffic.Model.TT_BadRecord model)
{
#region ������¼
SqlParameter[] parameters = {
new SqlParameter("@RecordID", SqlDbType.VarChar,32),
new SqlParameter("@NavicertCode", SqlDbType.VarChar,20),
new SqlParameter("@RoomCode", SqlDbType.VarChar,10),
new SqlParameter("@CarNo", SqlDbType.NVarChar,20),
new SqlParameter("@Decript", SqlDbType.NVarChar,200),
new SqlParameter("@BreakDate", SqlDbType.DateTime),
new SqlParameter("@AlarmType", SqlDbType.VarChar,50),
new SqlParameter("@AlarmStatus", SqlDbType.VarChar,1),
new SqlParameter("@CollCode", SqlDbType.VarChar,10),
new SqlParameter("@FrontImage", SqlDbType.VarChar,32),
new SqlParameter("@FrontImageContent",SqlDbType.Image),
new SqlParameter("@BackImage", SqlDbType.VarChar,32),
new SqlParameter("@BackImageContent", SqlDbType.Image),
new SqlParameter("@UpImage", SqlDbType.VarChar,32),
new SqlParameter("@UpImageContent", SqlDbType.Image),
new SqlParameter("@RoomImage", SqlDbType.VarChar,32),
new SqlParameter("@RoomImageContent", SqlDbType.Image)
};
parameters[0].Value = model.RecordID;
parameters[1].Value = model.NavicertCode;
parameters[2].Value = model.RoomCode;
parameters[3].Value = model.CarNo;
parameters[4].Value = model.Decript;
parameters[5].Value = model.BreakDate;
parameters[6].Value = model.AlarmType;
parameters[7].Value = model.AlarmStatus;
parameters[8].Value = model.CollCode;
parameters[9].Value = model.FrontImage;
parameters[10].Value = model.FrontImageContent;
parameters[11].Value = model.BackImage;
parameters[12].Value = model.BackImageContent;
parameters[13].Value = model.UpImage;
parameters[14].Value = model.UpImageContent;
parameters[15].Value = model.RoomImage;
parameters[16].Value = model.RoomImageContent;
#endregion
try
{
DataSet ds = DbHelperSQL.RunProcedure("PT_BadRecord", parameters, "TT_BadRecord");
if (ds != null)
return ds.Tables[0].Rows[0][0].ToString();
else
return "";
}
catch
{
return "";
}
}
/// <summary>
/// 购买标识卡
/// </summary>
public bool Add(string strNewMarkedCardNo, string strNewMarkedCardCode, CoalTraffic.Model.TT_MarkedCard model)
{
//对数据库中已有的记录，更新记录
string[] cardno = null;
string[] cardcode = null;
List<string> listSql = new List<string>();
List<SqlParameter[]> listParm = new List<SqlParameter[]>();
StringBuilder strSql = new StringBuilder("");
StringBuilder strAll = new StringBuilder("");
int i = 0;
if (model.MarkedCardNo != "")
{
cardno = model.MarkedCardNo.Split('|');
cardcode = model.MarkedCardCode.Split('|');
for (i = 0; i < cardno.Length; i++)
{
strAll.Append("update TT_MarkedCard set ");
strAll.Append("CollCode='" + model.CollCode + "',");
strAll.Append("CoalKindCode='" + model.CoalKindCode + "',");
strAll.Append("MarkedCardState='1',");
strAll.Append("SendCardDate='" + model.SendCardDate + "',");
strAll.Append("Operator='" + model.Operator + "',");
strAll.Append("DepartName='" + model.DepartName + "'");
strAll.Append(" where MarkedCardCode='" + cardcode[i] + "';");
//往标识卡记录表里添加记录
strAll.Append("insert into TT_MarkedCardSendRecord(");
strAll.Append("MarkedCardNo,MarkedCardCode,CollCode,CoalKindCode,SendCardDate,Operator,DepartName,SendType)");
strAll.Append(" values (");
strAll.Append("'" + cardno[i] + "','" + cardcode[i] + "','" + model.CollCode + "','" + model.CoalKindCode + "','" + model.SendCardDate + "','" + model.Operator + "','" + model.DepartName + "','购买');");
}
}
if (strNewMarkedCardNo != "")
{
//对数据库中没有的卡号，添加记录
cardno = strNewMarkedCardNo.Split('|');
cardcode = strNewMarkedCardCode.Split('|');
for (i = 0; i < cardno.Length; i++)
{
strAll.Append("insert into TT_MarkedCard(");
strAll.Append("MarkedCardNo,MarkedCardCode,CollCode,CoalKindCode,MarkedCardState,SendCardDate,Operator,DepartName)");
strAll.Append(" values (");
strAll.Append("'" + cardno[i] + "','" + cardcode[i] + "','" + model.CollCode + "','" + model.CoalKindCode + "','1','" + model.SendCardDate + "','" + model.Operator + "','" + model.DepartName + "');");
strAll.Append("insert into TT_MarkedCardSendRecord(");
strAll.Append("MarkedCardNo,MarkedCardCode,CollCode,CoalKindCode,SendCardDate,Operator,DepartName,SendType)");
strAll.Append(" values (");
strAll.Append("'" + cardno[i] + "','" + cardcode[i] + "','" + model.CollCode + "','" + model.CoalKindCode + "','" + model.SendCardDate + "','" + model.Operator + "','" + model.DepartName + "','购买');");
}
}
int iFlag = DbHelperSQL.ExecuteSql(strAll.ToString());
return iFlag > 0 ? true : false;
}
