public int Update(DataTable table)
{
if (_tablename != "")
{
string keyname = "";//Helper
string condition = "";
int rowcount = table.Rows.Count;
char[] charSeparators = new char[] { ',' };
DBAccess.DBHelper h = new DBAccess.DBHelper();
keyname = h.GetKeyField(_tablename);
SqlDataAdapter adapter = h.GetSqlDataAdapter(_tablename);
string[] keylist = keyname.Split(charSeparators, System.StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < rowcount; i++)
{
condition = "(1=1)";
for (int j = 0; j < keylist.Length; j++)
{
condition = condition + " and " + keylist[j] + "='" + table.Rows[i][keylist[j]].ToString() + "' ";
}
adapter.SelectCommand.CommandText = "select * from " + _tablename + " where " + condition;
DataSet desDS = new DataSet(_tablename);
adapter.Fill(desDS);
if (desDS.Tables[0].Rows.Count > 0)//������������
{
for (int descount = 0; descount < desDS.Tables[0].Rows.Count; descount++)
for (int k = 0; k < (table.Columns.Count - 1); k++)//Ĭ������£������ݱ����һ���ֶξ�ΪtableID��Ϊ�Զ���ţ�������ԶԴ��ֶεĴ���
desDS.Tables[0].Rows[descount][table.Columns[k].ColumnName.ToString()] = table.Rows[i][table.Columns[k].ColumnName.ToString()];
}
else//�������������
{
if (_findthenupdate)
{
DataRow row = desDS.Tables[0].NewRow();
for (int k = 0; k < (table.Columns.Count - 1); k++)
row[table.Columns[k].ColumnName.ToString()] = table.Rows[i][table.Columns[k].ColumnName.ToString()];
desDS.Tables[0].Rows.Add(row);
}
else
{
throw new DBKeyViolationException();
}
}
string s = adapter.UpdateCommand.CommandText;
adapter.Update(desDS);
}
return 0;
}
else
return -3;//δ���ñ���
}
public int Update(MyWebControlLib.FieldValues FV, int tableID)
{
if (_tablename != "")
{
DBAccess.DBHelper h = new DBAccess.DBHelper();
SqlDataAdapter adapter = h.GetSqlDataAdapter(_tablename);
adapter.SelectCommand.CommandText = "select * from " + _tablename + " where tableID=" + tableID.ToString();
DataSet ds = new DataSet(_tablename);
adapter.Fill(ds, _tablename);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow row = ds.Tables[0].Rows[0];
for (int i = 0; i < FV.Count; i++)
{
if (FV[i].Value == null)
{
row[FV[i].FieldName] = System.DBNull.Value;
}
else
{
row[FV[i].FieldName] = FV[i].Value;
}
}
try
{
adapter.Update(ds, _tablename);
return 0;
}
catch
{
return -1;
}
}
else
//Ϊ�ҵ���ؼ�¼
return -2;
}
else
return -3;//δ���ñ���
}
public int Delete(MyWebControlLib.FieldValues FVS)
{
if (_tablename != "")
{
DBAccess.DBHelper h = new DBAccess.DBHelper();
SqlDataAdapter adapter = h.GetSqlDataAdapter(_tablename);
string condition = " (1=1) ";
for (int i = 0; i < FVS.Count; i++)
{
string values = "";
FVOperater o = FVS[i].FVOperater;
switch (o)
{
case FVOperater.Great:
values = " > '" + FVS[i].Value + "' ";
break;
case FVOperater.Less:
values = " < '" + FVS[i].Value + "' ";
break;
case FVOperater.LikeB:
values = " Like '%" + FVS[i].Value + "' ";
break;
case FVOperater.LikeBE:
values = " Like '%" + FVS[i].Value + "%' ";
break;
case FVOperater.LikeE:
values = " Like '" + FVS[i].Value + "%' ";
break;
case FVOperater.NotGreat:
values = " <= '" + FVS[i].Value + "' ";
break;
case FVOperater.NotLess:
values = " >= '" + FVS[i].Value + "' ";
break;
case FVOperater.In:
values = " in (" + FVS[i].Value + ") ";
break;
case FVOperater.NotIn:
values = " not in (" + FVS[i].Value + ") ";
break;
case FVOperater.NotEqual:
values = " <> '" + FVS[i].Value + "' ";
break;
case FVOperater.Order:
break;
default:
values = " = '" + FVS[i].Value + "' ";
break;
}
condition = condition + _conditionOperater + FVS[i].FieldName + values;
}
adapter.SelectCommand.CommandText = "select * from " + _tablename + " where " + condition;
DataSet ds = new DataSet(_tablename);
adapter.Fill(ds, _tablename);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
ds.Tables[0].Rows[i].Delete();
//ʹ��������V2
DBAccess.DBHelper dh = new DBAccess.DBHelper();
dh.Update(ds);
//��ʹ��������V1
//adapter.Update(ds,_tablename);
return 0;
}
else
return -3;
}
public int Updata(DataSet ds)
{
DBAccess.DBHelper dbhelper = new DBAccess.DBHelper();
if (dbhelper.Update(ds) == 0)
{
return 0;
}
else
{
return 1;
}
}
public int Add(MyWebControlLib.FieldValues FV)
{
if (_tablename != "")
{
DBAccess.DBHelper h = new DBAccess.DBHelper();
SqlDataAdapter adapter = h.GetSqlDataAdapter(_tablename);
DataSet ds = new DataSet(_tablename);
adapter.Fill(ds, _tablename);
DataRow row = ds.Tables[0].NewRow();
for (int i = 0; i < FV.Count; i++)
{
row[FV[i].FieldName] = FV[i].Value;
}
ds.Tables[0].Rows.Add(row);
try
{
adapter.Update(ds, _tablename);
return 0;
}
catch
{
return -1;
}
}
else
return -3;//δ�趨����
}
