public int Add(FishEntity.SampleSingleEntity model)
{
StringBuilder Strsql = new StringBuilder();
Strsql.Append("insert into t_samplesingle(code,ferryName,BillOfLadingNumber,PileAngle,tdate,createtime,createman,modifytime,modifyman)");
Strsql.Append("values (@code,@ferryName,@BillOfLadingNumber,@PileAngle,@tdate,@createtime,@createman,@modifytime,@modifyman);");
Strsql.Append("select last_insert_id();");
MySqlParameter[] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@ferryName", MySqlDbType.VarChar, 45),
new MySqlParameter("@BillOfLadingNumber", MySqlDbType.VarChar, 45),
new MySqlParameter("@PileAngle", MySqlDbType.VarChar, 45),
new MySqlParameter("@tdate", MySqlDbType.DateTime),
new MySqlParameter("@createtime", MySqlDbType.Timestamp),
new MySqlParameter("@createman", MySqlDbType.VarChar, 45),
new MySqlParameter("@modifytime", MySqlDbType.Timestamp),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45)
};
parameters[0].Value = model.Code;
parameters[1].Value = model.FerryName;
parameters[2].Value = model.BillOfLadingNumber;
parameters[3].Value = model.PileAngle;
parameters[4].Value = model.Tdate;
parameters[5].Value = model.Createtime;
parameters[6].Value = model.Createman;
parameters[7].Value = model.Modifytime;
parameters[8].Value = model.Modifyman;
int id = MySqlHelper.ExecuteSqlReturnId(Strsql.ToString(), parameters); //MySqlHelper.ExecuteSql(strSql.ToString(), parameters);
return(id);
}
public override int Query()
{
panel1.Enabled = true;
if (_Form == null)
{
_Form = new UIForms.FormSampleSingleCodition();
_Form.StartPosition = FormStartPosition.CenterParent;
_Form.ShowInTaskbar = false;
}
if (_Form.ShowDialog() != System.Windows.Forms.DialogResult.OK)
{
return(0);
}
_where = _Form.GetWhereCondition;
List <FishEntity.SampleSingleEntity> list = _bll.GetModelListVo(_where + _rolewhere + _orderBy);
if (list == null || list.Count < 1)
{
_fish = null;
return(1);
}
else
{
_fish = list[0];
SetOnepound();
}
return(1);
}
public List <FishEntity.SampleSingleEntity> GetModelListVo(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from t_SampleSingle ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
DataSet ds = MySqlHelper.Query(strSql.ToString());
List <FishEntity.SampleSingleEntity> modelList = new List <FishEntity.SampleSingleEntity>();
int rowsCount = ds.Tables[0].Rows.Count;
FishEntity.SampleSingleEntity model;
for (int n = 0; n < rowsCount; n++)
{
DataRow row = ds.Tables[0].Rows[n];
model = new FishEntity.SampleSingleEntity();
if (row["id"].ToString() != "")
{
model.Id = int.Parse(row["id"].ToString());
}
if (row["code"] != null && row["code"].ToString() != "")
{
model.Code = row["code"].ToString();
}
if (row["ferryName"] != null && row["ferryName"].ToString() != "")
{
model.FerryName = row["ferryName"].ToString();
}
if (row["BillOfLadingNumber"] != null && row["BillOfLadingNumber"].ToString() != "")
{
model.BillOfLadingNumber = row["BillOfLadingNumber"].ToString();
}
if (row["PileAngle"].ToString() != "" && row["PileAngle"] != null)
{
model.PileAngle = row["PileAngle"].ToString();
}
if (row["tdate"] != null && row["tdate"].ToString() != "")
{
model.Tdate = DateTime.Parse(row["tdate"].ToString());
}
modelList.Add(model);
}
return(modelList);
}
public bool Update(FishEntity.SampleSingleEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_samplesingle set ");
strSql.Append("code = @code,");
strSql.Append("ferryName = @ferryName,");
strSql.Append("BillOfLadingNumber = @BillOfLadingNumber,");
strSql.Append("PileAngle = @PileAngle,");
strSql.Append("tdate = @tdate,");
strSql.Append("modifytime = @modifytime,");
strSql.Append("modifyman = @modifyman ");
strSql.Append("where id = @id");
MySqlParameter[] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@ferryName", MySqlDbType.VarChar, 45),
new MySqlParameter("@BillOfLadingNumber", MySqlDbType.VarChar, 45),
new MySqlParameter("@PileAngle", MySqlDbType.VarChar, 45),
new MySqlParameter("@tdate", MySqlDbType.DateTime),
new MySqlParameter("@modifytime", MySqlDbType.Timestamp),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.Code;
parameters[1].Value = model.FerryName;
parameters[2].Value = model.BillOfLadingNumber;
parameters[3].Value = model.PileAngle;
parameters[4].Value = model.Tdate;
parameters[5].Value = model.Modifytime;
parameters[6].Value = model.Modifyman;
parameters[7].Value = model.Id;
int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public override void Save()
{
FishEntity.SampleSingleEntity _fish = new FishEntity.SampleSingleEntity();
_fish.Code = FishBll.Bll.SequenceUtil.GetSampleSingleSequence();
_fish.FerryName = txtferryName.Text.Trim();
_fish.BillOfLadingNumber = txtBillOfLadingNumber.Text.Trim();
_fish.PileAngle = txtPileAngle.Text.Trim();
_fish.Tdate = dtptdate.Value;
_fish.Createtime = DateTime.Now;
_fish.Createman = FishEntity.Variable.User.username;
_fish.Modifytime = DateTime.Now;
_fish.Modifyman = FishEntity.Variable.User.username;
FishBll.Bll.SampleSingleBll bll = new FishBll.Bll.SampleSingleBll();
bool isok = bll.Exists(_fish.Code);
while (isok)
{
_fish.Code = FishBll.Bll.SequenceUtil.GetSampleSingleSequence();
isok = bll.Exists(_fish.Code);
}
int id = bll.Add(_fish);
if (id > 0)
{
_fish.Id = id;
tmiQuery.Visible = false;
tmiDelete.Visible = false;
tmiModify.Visible = false;
tmiAdd.Visible = false;
tmiSave.Visible = true;
tmiCancel.Visible = true;
MessageBox.Show("添加成功。");
txtcode.Text = _fish.Code.ToString();
}
else
{
// txtCode.Text = _fish.Code;
MessageBox.Show("添加失败。");
}
}
public bool Update(FishEntity.SampleSingleEntity model)
{
return(dal.Update(model));
}
public int Add(FishEntity.SampleSingleEntity model)
{
return(dal.Add(model));
}
